best avialability option over a WAN
-
Hi Folks,
what do people think is the best high availability option over a WAN link?
(replication, log shipping mirroring etc)
to elaborate.. my boss wants me to ship our databases over to a DR site as a form of backup. I thought transactional replication may be the go but not so sure now
-
Well the fact that it's a wan is a lot less important than the speed of that wan. How does it compare with the rest of the lan?
And this whole exercise really hinges off of what you're after in a DR strategy and what else you have in play more than it does on the wan. Sure, your options will be limited based off of the wan, but your company needs to establish what they need first and then make a decision on the best way to implement. And that may include upgrading the wan if the data's important enough.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARantMinion Maintenance is FREE:
-
I tend to agree with Sean. It depends on a lot of things.
Log shipping/mirroring are nice in that they cover the database. Replication requires you to setup replication for all tables, and don't forget them.
None of these handles logins, packages and things outside your database.
Log shipping is nice in that if the link is down, you could use other methods to get the log backups over there. Mirroring you'd need to get the link back up.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply