SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 If mirror stopped for 12 hours, will it re-synch
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqlguy7777
Starting Member

14 Posts

Posted - 12/08/2010 :  18:21:11  Show Profile  Reply with Quote
Hi

If i shutdown the SQL Mirror server for 12 hours and leave the Principal SQL server running, assuming there is no outage on the Principal SQL server and there is enough disk space for the log to grow, will the Principal re-sych without data loss back to the SQL Mirror server OK? We are running full safety synchonous with witness server.

Were doing testing for DR scenarios, and I wanted to know if I left the mirror server physically turned off for a long time, whether I would have to delete and rebuild the mirror set from scratch again as I am not sure if there is a "use-by" time for mirrored data?

Thanks in advance,


SG


  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000