Best database replication strategy for a consolidated SQL Server
Home > IT Answers > SQL Server > Best database replication strategy for a cons...
SQL Server Ask the Experts
2445 pts.
0
Q:
Best database replication strategy for a consolidated SQL Server
SQL Server, Database replication, SQL Server Consolidation
What database replication strategy would you employ on a consolidated SQL server?
ASKED: Nov 24 2008  8:02 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46795 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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 Answered: Nov 25 2008  5:10 AM GMT by Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0