Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachinsamuel
Constraint Violating Yak Guru
383 Posts |
 Posted - 2007-10-30 : 10:41:46
|
| Hi Experts,I am planning to create a disaster recovery site for my production database server. But I am not able to identify which option to choose. Not sure if I should go with database mirroring or transactional replication.What are the pros and cons of each option?Production and disaster recovery site location will be geographically very far.please helpRegards,SDon't sit back because of failure. It will come back to check if you still available. -- Binu |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-10-30 : 11:53:54
|
| http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72371http://msdn2.microsoft.com/en-us/library/ms190202.aspxhttp://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx#E6KAGDinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
Disaster Recovery