Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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 replication set up between 2 SQL Server 2008 servers, but I would like to reconfigure it again. Is it safe for me to remove replication during normal activity or should I wait until a low traffic time?

The replication is set up between 2 web servers on the same local network and the replicated DB is about 4.5 GB. It is very critical for the data to be online.

share|improve this question
up vote 0 down vote accepted

I would suggestion supplying more information. How much data is there to replicate, what bandwidth is available for replication (LAN vs WAN), how critical it is for the data to be online.

We've had issues in the past where replication locked certain tables, and because it was between a production server and a web server in a DMZ it took awhile to replicate our large database. For that reason I'm glad we tested replication during off hours, and we only configure it to run during off hours.

share|improve this answer
I added more information – Jonas Stawski Nov 17 '09 at 20:08

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.