September 14, 2005 at 9:20 pm
Hello:
Can someone clarify database mirroring for me. How many copies of sql server do I need to configure a database mirroring session involving three separate servers (that includes a witness server)?
The scenario is this: in the quorum, there are three servers: the principal server, the mirror server and the witness server. the principal server has the original db; the mirror server has a copy of the db on principal server; the witness server watches both the principal server and the mirror server. If the principal server goes down, the witness automatically tells the mirror server to take over as principal server, a process that takes 3 seconds.
To establish the mirror session for all three servers, according MS eLearning course 2938, I perform the following:
For the principal server's participation in the quorum:
1) from the principal server, I run the alter database statement on the original db
For the mirror server's participation in the quorum:
2) from the mirror server, I run the alter database statement on the mirror db
For the witness server's participation in the quorum:
3) from the PRINCIPAL server, I run the alter database statement on the original db
Given step 3), I can't tell if I need 2 or 3 copies of sql server (ie. do I need a copy of sql server on the witness server?) Am I missing something here?
Thanks in advance,
Billy
September 15, 2005 at 8:40 am
Yes,
You do need a copy of SQL Server on the witness server. The good news is that this copy can be SQL Express (the MSDE of SQL 2005) which is free.
September 16, 2005 at 1:24 pm
You might just want to hang this one up. MS just announced yesterday (09/15/2005) that 'mirroring' in SQL 2K5 is not ready for release. You can turn it on with MS permission under limited circumstances but you will not get any support.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
September 16, 2005 at 4:21 pm
We're hoping that it will get activated in a service pack. Fingers crossed.
September 22, 2005 at 9:29 am
Just heard that in SQL 2005 roadshow in cincinnati. Cheers - Babu.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply