Configure SQL Witness

Dear All,

I have three SQL 2008 R2 servers, i need to configure one of them as a Witness server, and others as mirror servers.

I need to know how i can configure the Witness? is there a configuration? i have now idea about the configuration?

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Creating certificates are available at this link
If you wait for 2 days I will give a script that I have done in MSSQL 2005 .
There are several examples within EE
I think the above link references the below link, but if not

The simple process is to use ssms.
Transfer the logins frm the current server to the other
This is needed in the event you transitin to the mirror, the databases uses the SID rather than a username to grant rights.

Create a backup of the database and transfer it to the second server.
On the second server (the one that will be the mirror), Restore the database leaving it in recovery mode. (Do not bring it online).
On the main server right click on the database, properties/mirror.
The wizard is fairly straight forward, you have a choice whether you want to setup with or without a witness. The witness can be added/removed as long as the setup has two functions. Te draw back against w/ witness is that should the mirror and witness go down (power, connectivity, etc) the database will become inaccessible as well.  In a mirror with witness, any combination of two nodes must be online for the mirrored database to be online.

Go through the wizard, and upon completion start the mirror. Te issue at times depends on how active your database is.  To establish mirroring, some transactions must have occurred since the backup was taken, I.e. if there were no transactions since the backup was taken, there are no transactions to push which are used to confirm the establishment of the mirroring setup.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.