Home > IT Answers > Database > Best database replication strategy for a consolidated SQL Server
SQL Server Ask the Experts
2,585 pts.
 Best database replication strategy for a consolidated SQL Server
Database replication, SQL Server, SQL Server Consolidation
What database replication strategy would you employ on a consolidated SQL server?

Software/Hardware used:
ASKED: November 24, 2008  8:02 PM
UPDATED: November 25, 2008  5:10 AM
RELATED QUESTIONS
Answer Wiki:
That depends on your goals. If you want to setup two servers which can both be written to then merge replication will do the trick. If you want to setup a backup server that you can fail over to then replication isn't going to be the right solution; database mirroring is. Can you provide more information as to what you are trying to do?
Last Wiki Answer Submitted:  November 25, 2008  5:10 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _