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

Suspending Database Mirroring Expand / Collapse
Author
Message
Posted Thursday, December 20, 2012 3:59 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 20, 2013 4:45 AM
Points: 236, Visits: 239
Hi All

Does anybody know if suspending db mirroring prevents automatic failover should the primary fail ?
I know that Suspending stops transactions being sent to the mirror and the principal runs exposed, but would the witness still attempt to failover should the primary become unavailable ?

Thanks in advance

Preet
Post #1398892
Posted Wednesday, December 26, 2012 3:08 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, July 18, 2014 11:32 AM
Points: 709, Visits: 1,410
I do not believe so.

Automatic failover requires the following conditions:

The database mirroring session must be running in high-safety mode and must possess a witness. For more information, see Synchronous Database Mirroring (High-Safety Mode).

The mirror database must already be synchronized. This guarantees that all of the log sent to the mirror server has been written to disk.


Automatic Failover


Joie Andrew
"Since 1982"
Post #1400195
Posted Thursday, December 27, 2012 6:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 1:14 PM
Points: 9, Visits: 90
No it most certainly will not failover automatically.
Post #1400593
Posted Thursday, December 27, 2012 8:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:12 AM
Points: 397, Visits: 2,410
Preet_S (12/20/2012)
Hi All

Does anybody know if suspending db mirroring prevents automatic failover should the primary fail ?
I know that Suspending stops transactions being sent to the mirror and the principal runs exposed, but would the witness still attempt to failover should the primary become unavailable ?

Thanks in advance

Preet


I believe, suspending mirroring means, it's paused somehow, can be done manually or can cause by many different things.....It can be due to network failure, or space issues.

Does anyone know what else can cause the mirroring to be in a suspended state?

SueTons.


Regards,
SQLisAwe5oMe.
Post #1400652
Posted Friday, December 28, 2012 2:24 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:58 AM
Points: 6,166, Visits: 13,308
SQLCrazyCertified (12/27/2012)
Does anyone know what else can cause the mirroring to be in a suspended state?

SueTons.

Creating a new file on the principal when the file paths between the principal and the mirror are different


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

"Ya can't make an omelette without breaking just a few eggs"
Post #1400842
Posted Friday, December 28, 2012 6:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:12 AM
Points: 397, Visits: 2,410
Perry Whittle (12/28/2012)
SQLCrazyCertified (12/27/2012)
Does anyone know what else can cause the mirroring to be in a suspended state?

SueTons.

Creating a new file on the principal when the file paths between the principal and the mirror are different


Hi P


Regards,
SQLisAwe5oMe.
Post #1400891
Posted Friday, December 28, 2012 6:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:12 AM
Points: 397, Visits: 2,410
Perry Whittle (12/28/2012)
SQLCrazyCertified (12/27/2012)
Does anyone know what else can cause the mirroring to be in a suspended state?

SueTons.

Creating a new file on the principal when the file paths between the principal and the mirror are different


Hi P


Regards,
SQLisAwe5oMe.
Post #1400892
Posted Friday, December 28, 2012 6:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 5:12 AM
Points: 397, Visits: 2,410
Perry Whittle (12/28/2012)
SQLCrazyCertified (12/27/2012)
Does anyone know what else can cause the mirroring to be in a suspended state?

SueTons.

Creating a new file on the principal when the file paths between the principal and the mirror are different


Hi Perry,

Can u explain what exactly you mean creating a file, are you talking about new ndf file? Please advise with some example if you don't mind.

SueTons.


Regards,
SQLisAwe5oMe.
Post #1400894
Posted Friday, December 28, 2012 7:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:58 AM
Points: 6,166, Visits: 13,308
If you have a principal server with database file path "D:\MSSQL\MYDBS" and you create the database file "D:\MSSQL\MYDBS\adventureworks_data2.mdf" and the path does not exist on the mirror, this will cause the mirror session to be suspended.
This link details that for mirroring to work seamlessly, the file paths should be synchronised between the servers.


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

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

Add to briefcase

Permissions Expand / Collapse