What is the best practice for moving an existing subscription to a new server?
We have a new sql server that will replace the server where my replicated database lives, so I would like to move the replicated database to the new server & change the publication to point to the new server, is this possible? Seems like it would provide the least amount of interruption....
Hilary, if you cover this in your book, what chapter?
Thanx!
The simplest way is to create a new subscription on the new server and initialize. If all the data is synced up, you could do a nosync initialization to avoid the flow of data.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
|||Good idea! Thanx!
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message news:uxxecZRtFHA.1168@.TK2MSFTNGP11.phx.gbl...
The simplest way is to create a new subscription on the new server and initialize. If all the data is synced up, you could do a nosync initialization to avoid the flow of data.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book: http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment