Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kennetu
Starting Member
33 Posts |
 Posted - 2009-09-02 : 10:46:50
|
| I recently configured SQL Server 2005 database mirroring in one of my company's production environments. How can the mirror server take the role of the Principal server if the principal server crashes. Thanks; I appreciate your prompt response.Best regards,Kenneth. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kennetu
Starting Member
33 Posts |
Posted - 2009-09-03 : 04:39:18
|
| Get me right now. I have finished the configuration of the database mirroring without a witness server option, and it is working very fine. My question goes this way: If the principal server fails, can the mirror server fail over automatically? If not, how can the mirror server take over the role of the principal server explicitly?I need your urgent reply.Kenneth. |
 |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 07:02:28
|
quote:
Originally posted by kennetu
I have finished the configuration of the database mirroring without a witness server option, and it is working very fine. My question goes this way: If the principal server fails, can the mirror server fail over automatically? If not, how can the mirror server take over the role of the principal server explicitly?
No, without a witness server it will not perform automatic failover. From BOL:quote:
Automatic failover This requires high-safety mode and the presence of the mirror server and a witness...
And Tara's link shows you how to do the manual failover.More info: http://technet.microsoft.com/en-us/library/cc917681.aspx========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
|
|
|
kennetu
Starting Member
33 Posts |
Posted - 2009-09-03 : 10:24:25
|
| Thanks so much. I know that automatic failover is only possible when an witness server is involved. Which configuration/scripting can be used to get notified whenever the principal server crashes, in order to reduce downtime? |
|
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 13:34:38
|
| You would want to set up an alert for that: http://msdn.microsoft.com/en-us/library/cc966392.aspx========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2009-09-04 : 12:22:12
|
| We don't use database mirroring alerts to check for the principal server crashing. Instead we use tools to monitor our environments. For SQL Server, Windows, and clustering, we use MOM to monitor our environments. The applications have custom monitoring in place, so they would also catch the situation where the database server was no longer available.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog"Let's begin with the premise that everything you've done up until this point is wrong." |
|
|
|
|
|
|
|
|
Database Mirroring