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

I have the following transactional replication setup:

Windows Server 2008 with SQL Server 2008 Enterprise

Server A: Master, has a database with a table, publisher
Server B: Slave, subscriber (Backup server)

For backup (and read only access to B during down time), transactional replication is a good solution. However, during downtime of A, I want the application to read and write to the database on B. It is possible to backup B and restore the content to A, but is a merge replication a better way?

share|improve this question

for backup purposes I would implement database mirroring. if read access is required then using database snapshots could help.

i believe that merge replication would work to eliminate the need to backup/restore from B to A, but the performance penalty would be considerable. if the base is small then it would be fine.

share|improve this answer

Your Answer


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

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