Calling all replication gurus...restore question

Last Post 21 Mar 2006 02:23 PM by Lee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

21 Mar 2006 02:23 PM
I have several databases on our staging environment that must be restored from production, which usually happens every 3 weeks or so. We are now doing replication on those databases to another "reporting" server. When I restore it completely hoses up the publications and subscriptions. Is there any way at all to restore databases and keep these? What would be a good way to restore replication if there is not - scripts? I would have to script the entire thing, including jobs, etc. When i try to resynch with the new databases it gives me errors...can't figure out how to do it.


Acceptable Use Policy