December 11, 2006 at 2:06 pm
Anyone?
I currently have a sql2000 standard edition distributor running several publications and subscriptions from other servers. I have a new SQL 2005 standard edition server that I would like to implement. My thought is to stop replication. Put all of the publishers in read-only mode so that no new transactions can occur. Script all of the publications and subscriptions out. Drop all of the subscriptions and publications. Link the 2005 distributor to the servers and recreate all of the subscriptions and publictions. Anyone got any ideas on exactly how I need to do this? I am searching BOL
December 11, 2006 at 3:56 pm
I don't see any problem...
1. backup database...
2. Script replication...
3. Remove all subscriptions...
4. Remove all publications...
5. Disable replication on the...or remove replication...
6. Restore all user databases on to new server.
7.Enable for replication...Configure publisher..
8. Run the scripts to create publications and subscriptions only (This script must be tested in dev before running on production... because I am not sure...)
http://msdn2.microsoft.com/en-us/library/ms143470.aspx
The above article says you can if you are sysadmin...
9. If step8 is not working then reconfigure publications and subscriptions...
10. Transfer the logins using sp_help_revlogin proc...
http://support.microsoft.com/kb/918992/
MohammedU
Microsoft SQL Server MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply