nikhil.verma
SSCrazy
Points: 2603
More actions
December 9, 2008 at 4:05 pm
#129210
I have one backup file ( sql server 2000) and want to restore the same to sql server 2005 database which is a replicated database. Can anyplease please guide me the steps to do the restoration in case of replication.
Thanks
MANU-J.
SSC-Dedicated
Points: 31126
December 11, 2008 at 11:49 am
#911268
You will have to drop the 2005 database prior to restoration. Just script out the subscribers list and publications.
After restoration you need to set up replication again and execute the script taken out before restoration.
Mj
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply