Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. 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

This question already has an answer here:

Are there any methods (mirroring, snapshot replication, change tracking, etc...) available in SQL Server 2k8 which would allow me to replicate production data to several individual development databases AND allow separate data to be written to each of those dev db?

In other words: Once a full copy of data is replicated to a dev database, replication would be turned off so new data can then be written to the dev database without impacting the production database.

Thanks in advance

share|improve this question

marked as duplicate by Max Vernon, RolandoMySQLDBA, Paul White, swasheck, Kin Nov 26 '13 at 3:52

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

Wouldn't simple backup/restore be enough? Just restore the production backup on all your dev servers and you should be fine. Btw. Sql server does not allow writes to replica servers as it would corrupt the data and it would no longer be able to figure out what should be updated.

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.