Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2012-01-26 : 07:20:00
|
| Hi,We have a pair of mirrored servers (server A Principle and server B Mirror) running in High Safety, no witness. We need to move the physical location of server B which will cause approx 3 hours downtime to the mirror server. The last time we did something very similar to this we experienced problems due to the fact that while the mirror was offline the transactions queued at the principle as no acknowledgement could be received from the mirror. Also, replication on the principle was hit because the transactions were not being commited to the log.Is there a correct way to handle this scenario to avoid problems while there is no available mirror server? Should the status for each mirrored database be set to 'Paused' or similar?Any help or advice would be appreciated. |
|
|
|
|
|
Mirroring best practice for server move