<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Suspending Database Mirroring
Suspending Database Mirroring
Rate Topic
Display Mode
Topic Options
Author
Message
Preet_S
Preet_S
Posted Thursday, December 20, 2012 3:59 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 5:15 AM
Points: 236,
Visits: 235
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
Joie Andrew
Joie Andrew
Posted Wednesday, December 26, 2012 3:08 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Today @ 5:06 AM
Points: 543,
Visits: 1,017
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
kenneth.gore
kenneth.gore
Posted Thursday, December 27, 2012 6:23 AM
Forum Newbie
Group: General Forum Members
Last Login: Thursday, May 16, 2013 11:13 AM
Points: 4,
Visits: 75
No it most certainly will not failover automatically.
Post #1400593
SQLCrazyCertified
SQLCrazyCertified
Posted Thursday, December 27, 2012 8:53 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 312,
Visits: 1,860
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.
Post #1400652
Perry Whittle
Perry Whittle
Posted Friday, December 28, 2012 2:24 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 5,201,
Visits: 11,153
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
SQLCrazyCertified
SQLCrazyCertified
Posted Friday, December 28, 2012 6:38 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 312,
Visits: 1,860
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
Post #1400891
SQLCrazyCertified
SQLCrazyCertified
Posted Friday, December 28, 2012 6:38 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 312,
Visits: 1,860
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
Post #1400892
SQLCrazyCertified
SQLCrazyCertified
Posted Friday, December 28, 2012 6:40 AM
Old Hand
Group: General Forum Members
Last Login: Yesterday @ 1:52 PM
Points: 312,
Visits: 1,860
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.
Post #1400894
Perry Whittle
Perry Whittle
Posted Friday, December 28, 2012 7:06 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 7:36 AM
Points: 5,201,
Visits: 11,153
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 »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
