Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to figure out the proper procedure to overwrite a database with a backup of a database created on a different server. The backup has an identical schema, full text indexes, stored procs, etc. The only thing that differs is the data. The user table current replicates to another database, so I need to restore this database while maintaining this replication. Any tips on how I can do this?

Thanks in advance for your assistance!

share|improve this question

migrated from Apr 26 '11 at 11:18

This question came from our site for professional and enthusiast programmers.

You'll have to tear down replication and build it back up again (along with reinitializing any subscribers). The easiest/most reliable way to do this is through T-SQL scripts. To drop, it's going to be calls to sp_dropsubscription, sp_droparticle, and sp_droppublication and to re-add it's going to be sp_addpublication, sp_addarticle, and sp_addsubscription. Good luck... you'll learn lots!

share|improve this answer
Thanks! That's a good start, much appreciated! – Brett Apr 25 '11 at 19:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.