Log ship strategy
If we log ship, the initialisation could take 4-8 hours due to connection. This itself is not a probem
However, if in future we have a db failure at site A, then (as I understand it) our only way to restore is either to take a backup of the mirror at B and apply subsequent logs. However the time to transfer the backup from site B would be too long from a business continuity perspective.
So... What we really want is the log ship, but with to hold a backup of the database at site A, on to which we can apply the subsequent logs i.e so we don't have to pull the bulk of the data back from site B.
Is there a way of doing this?