Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Mirroring and SQL Agent Job on principle Expand / Collapse
Author
Message
Posted Saturday, March 15, 2014 10:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 6,366, Visits: 13,696
smtzac (3/15/2014)
Yes. Recovering the Database. I don't think you can switch Principle server to Mirror if Principle is down, can you?

Yes of course you can, but it's a manual failover using

 alter database [yourdb] set partner force_service_allow_data_loss



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1551497
Posted Saturday, March 15, 2014 2:53 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, September 7, 2014 5:20 PM
Points: 100, Visits: 356
what happens when principle comes back on? or will users know they are connecting the mirror? would plz share your knowledge on this or recommend any website which has 'Asynchronous' mirroring when disaster happens?
Thanks you
Post #1551518
Posted Saturday, March 15, 2014 3:08 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, September 19, 2014 11:08 AM
Points: 5,863, Visits: 12,941
The old principal will take up its role as the new mirror. Users may not be aware they are connecting to a mirror, and ideally should not care. There may have been a noticeable outage though.

read this thoroughly http://technet.microsoft.com/en-us/library/ms189977(v=sql.100).aspx


---------------------------------------------------------------------

Post #1551520
Posted Saturday, March 15, 2014 3:49 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:24 AM
Points: 6,366, Visits: 13,696
to add to George, the old principal will become the mirror but the session will be suspended. You will need to manually resume mirroring using


alter database [yourdb] set partner resume



-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1551522
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse