September 10, 2007 at 6:25 am
Hello all,
I have a snapshot replication, and need to rename a database that is a subscriber of a publication.
I set up this series of steps to follow:
Step1:
-script the publications that are on the Publication server (Publication script)
-script the subscriptions that are on the Subscription server (Subscription script)
-adjust the scripts to use the new database name
Step2:
-stop the replication
-start the Subscription server in single-user mode
-rename the database
-start the Subscription server in multi-user mode
Step3:
-run the Publication script and the Subscription script to create the new replication
-start the new replication
-test the result
Am I missing something? Is there an easier way?
What would you advice?
tia
Hans
September 11, 2007 at 3:09 am
Hi Hans,
Your plan should work. You don't need to cycle the subscription server in order to rename the database. Simply disconnect everyone, if they are too agressive then deny them, rename the db and re-enable user connections.
-- Erik http://blog.rollback.hu
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply