Take the 2-minute tour ×
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. It's 100% free, no registration required.

Current situation is we have 3 SQL Servers with one availablity group and we plan on moving one of the secondary replicas out of HQ to another location. There will be the span of a few hours between the transport of the server to the new location. Would it be best to suspend the databass on the replica and then resume once its up again?

share|improve this question
1  
Please define "moving". Will a completely different server become a secondary replica? Or will the current secondary replica just be down and then come back up? –  Thomas Stringer Feb 1 '13 at 14:32
    
Sorry, we will be powering off that replica and moving it to a new datacenter. Then powering it back up. –  mdmedina07 Feb 1 '13 at 15:30

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.