Calling all replication gurus...restore question

Last Post 21 Mar 2006 02:23 PM by Lee. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Lee
New Member
New Member

--
21 Mar 2006 02:23 PM
Hi,
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.

Thanks
You are not authorized to post a reply.

Acceptable Use Policy