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

Mirroring DR Test Question Expand / Collapse
Author
Message
Posted Tuesday, April 23, 2013 3:17 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:13 AM
Points: 37, Visits: 207
I am in the process of setting up Async db mirroring between principal and mirror (no witness server)

We're looking @ testing a forced failover to our mirrored server during the day, however I do not want the principal server to assume the position of the mirror and the mirror the principal.

I have not found any topics out here that answered this particular question but is there a forced way to put the mirror as the principal and leave the "production/principal" still readily available?

Going forward for a true dr test I want to force the principal to act as the mirror and the mirror to act as the principal, but for this internal test we don't want the production clients to experience any downtime.

any information would be greatly appreciated, thanks
Post #1445693
Posted Wednesday, April 24, 2013 12:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:00 AM
Points: 6,488, Visits: 13,963
You'll need to break the mirror session and restore the mirror database with recovery.

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

"Ya can't make an omelette without breaking just a few eggs"
Post #1445775
Posted Wednesday, April 24, 2013 3:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:13 AM
Points: 37, Visits: 207
Thanks for the feedback, that is kind of what I had expected, thank you for the clarification.
Post #1446242
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse