Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 12:45 PM
Points: 8,225, Visits: 16,374
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
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Yesterday @ 5:01 AM
Points: 111, Visits: 283
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


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 12:45 PM
Points: 8,225, Visits: 16,374
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