May 12, 2008 at 4:14 am
Hi,
I configured database mirroring in sql server 2005 with out a witness server and it is mirroring finely.I checked the manual failover and it is working.But when i stopped the services of the db engine ,the mirroring engine is not changing to principal server.Could you please explain me the reason ?Is witness mandatory?
May 12, 2008 at 4:53 am
Because you have not included the witness server it does'nt automatically update the status if you are stopping the sql server service. Automatic Failover is only supported if you include the witness server in your configuration. For example if your principal server crashed due to hardware failiure your mirror will not change its status to principal and you have to manual failover....
Basit Ali Farooq
[font="Courier New"](MCITP Database Administrator, MCDBA, MCSE, MCPD, MCSA)[/font]
Basit Ali Farooq
MCITP Database Administrator
Microsoft Certified Professional Developer (Web Applications)
Microsoft Certified Database Administrator
Microsoft Certified Systems Engineer
Microsoft Certified Systems Administrator
CIW Security Analyst
Cisco Certified Network Associate
May 12, 2008 at 6:59 am
As mentioned above, if you have witness server it will automatically perform the failover to the mirror server if the principal server is down. In your case since you don't have a witness server its not happening.
You can configure even a Sql Server express edition as witness server. You can download the same free of cost from,
http://msdn.microsoft.com/en-us/express/bb410792.aspx
[font="Verdana"]- Deepak[/font]
May 12, 2008 at 8:27 am
The witness server serves as sort of a tiebreak vote to decide which server is the primary. Without it it's like Gore/Bush, the server's won't know who won the vote. (sorry couldn't help a little political humour as it is election season again)
Marvin Dillard
Senior Consultant
Claraview Inc
May 13, 2008 at 7:33 am
Thanks for the solution .Now mirroring is working fine.I just want to know which scenario will be help ful if we configure mirroring.1.High performance 2. High availiability in a production machine
May 13, 2008 at 7:38 am
If your database is highly critical you need to go for High Availability mode which requires witness server and facilitates automatic failover.
[font="Verdana"]- Deepak[/font]
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply