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.