I use 2 servers and need to synchronize them. How can I do this? Both servers can change data (inserts and updates). I need both servers to have the same data.
You can do this with either transactional or merge. For transactional, you need to use immediate updating subscribers, or if you are running 2000, you could also use queued updating subscribers. Both methods will allow the data to flow in both directions. If the servers need to operate independently, then you need either merge or queued updating subscribers since if the publisher goes down with immediate updating, the subscriber cannot process any changes either. A good place to start would be in my replication section at http://www.mssqlserver.com/replication
For More Information
- What do you think about this answer? E-mail us at editor@searchDatabase.com with your feedback.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBA's and developers? The best tips submitted will receive a cool prize--submit your tip today!
- Ask your technical SQL Server questions--or help out your peers by answering them--in our live discussion forums.
- Ask the Experts yourself: Our SQL Server guru is waiting to answer your toughest questions.
Dig Deeper on Microsoft SQL Server Installation
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.