Disaster recovery

Question

How to implement Disaster Recovery for DB Mirroring,Replication and Clustering?

Answer 1

Database mirroring is a high availability in which mirrored server is not available

Clustering both the server must be in the same geographic location

replication both the servers are available , can work out of geograhical locations

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

Hello,

If you're looking for implementation information, I would suggest you look at BOL.

Mirroring: http://msdn.microsoft.com/en-us/library/ms189852.aspx

Clustering: http://msdn.microsoft.com/en-US/library/ms189134(v=sql.105).aspx

Replication: http://msdn.microsoft.com/en-us/library/ms151198%28v=SQL.105%29.aspx

-Sean

---

Sean Gallardy | Blog | Twitter