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 |
|
kalyani.esl
Starting Member
5 Posts |
 Posted - 2013-08-02 : 15:24:28
|
| There is one SQL Server 2005 with running transactional replication for 2 databases. The server is publisher and distributer.There is one SQL Server 2005 as a subscriber to these databases.Due to performance issues we are planning to separate distributor to a new server sql 2012.And subscriber also to sql2012. Let me know the steps on performing it as it is a production box. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-08-02 : 15:42:36
|
| Shutdown the applications to ensure no new data is flowing through the system. I also disable the logins to make sure they can't connect until I am done. Make sure replication is caught up by doing a tracer token. Drop replication on the publisher, backup/restore or detach/attach for the subscriber, point the publisher over to the new distributor, setup replication on the publisher.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
kalyani.esl
Starting Member
5 Posts |
Posted - 2013-08-02 : 16:50:46
|
| Thank You. |
|
|
|
|
|
|
Replication Setup information