SAN replication : WAN bandwidth sizing & comparison to MS SQL mirroring
I have a need to mirror a Production MS SQL DB to a remote hot site.
Would SAN replication be more efficient (ie requires less bandwidth
& less manual intervention in the event disaster strikes the Production
site) than MS SQL 2008 mirroring ?
Currently we have MS SQL log shipping with the SQL log ship files being
sent over a 50Mbps WAN at regular intervals to DR site (I suppose this
is to update the DR database as I'm new to this project). Can I base
the bandwidth required by taking the largest log ship file ever created
divided by the interval that the log ship file is being created?
Can this method of sizing the WAN bandwidth be used for both
SAN replication as well as MS SQL mirroring solutions?