Hi all,
I have a backup of a repliacted (Merge) database (SQL Server 2000).
What are the setups of restoring this merge database to a new server.
Please provide me with detailed steps on how to do this?
(I have restored this database the MSDB and Distribution database but it
did not work I cannot see the merge agent , also in the Configure Pulisher,
Distrubotor.., I still see the old Server Name)
Thanks for any help.
Abdu.
The servername exists in too much replication metadata for this to succeed.
The only way to have this work is to name the new server identically to the
old server and then restore. There are details in BOL for replication backup
and restore which outline the process.
HTH,
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