June 6, 2008 at 4:52 pm
Hi,
I have to restore a backup file(of same database on which replication is enabled) on the database which is involved in replication. Do I need to script out anything prior to restore? The backup is of the same database, we have to restore it because due to some problems client want to revert back to the same state of the database(when backup was actually performed).
I don't know whether I need to script out anything or do I need to create the subscriptions(merge replcation is implemented on the database) again once database restoration is done.
Plz help....
Manu Jaidka
June 10, 2008 at 12:37 pm
I would be doubt that you are able to restore the database before dropping your replication. As the result, I think you need to
1. Script out your replication first;
2. Drop the replication;
3. Restore the database;
4. Run the saved script for your replication.
June 10, 2008 at 2:32 pm
One question: Will subscribers come automatically after restoration or do i need to manually susbscribe to the publications after restore?
Thanks for the reply,
Manu
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply