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

Database Mirroring scenario Expand / Collapse
Author
Message
Posted Wednesday, March 19, 2014 5:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 6,420, Visits: 13,810
zedtec (3/19/2014)
Hi Perry,

No confusion.....Failover is performed at the principal server isn't it?

No, not when the principal is dead as you quoted in your scenario above. In this case you would use the following from the mirror to bring the mirror database online

ALTER DATABASE [somehadb] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS




zedtec (3/19/2014)
If the principal is down then how would failover take place?

That was my question in a nutshell.

see above


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1552552
Posted Wednesday, March 19, 2014 5:18 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 2:57 AM
Points: 53, Visits: 155
Yes you would use that and I know that now, but when I asked this question I didn't know about Forced Service.

That's why I asked about failover from principal as I didn't know you could do forced service on the mirror.

Post #1552558
Posted Wednesday, March 19, 2014 5:21 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:29 AM
Points: 6,420, Visits: 13,810
you know now

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

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

Add to briefcase ««12

Permissions Expand / Collapse