HI, I have two server's and both having Windows Server 2008 R2 and have install Microsoft SQL Server 2008. Our application and database in single server only. I want to setup a mirror between both the server's as 1st server get down then other server get automatically get switch. I have some notes which say some witness server need to setup. Please give me some step by step solution to setup this mirror's with witness server. Thanks, Sanket...

Read these 2 docs http://support.microsoft.com/kb/2001270 http://technet.microsoft.com/en-us/library/ms179306(v=sql.105).aspx Chuck

After configuring database, you should also reconfigure your application to be mirroring aware (check the link below). Database mirroring will not move your application to other server in case of server failure, you need to configure it separately and it depends on application architecture. http://msdn.microsoft.com/en-us/library/ms366348%28v=sql.105%29.aspx: For the initial connection to a mirrored database, a client must supply a connection string that minimally supplies the name of a server instance. This required server name should identify the current principal server instance and is known as the initial partner name. Optionally, the connection string can also supply the name of another server instance, which should identify the current mirror server instance, for use if the initial partner is unavailable during the first connection attempt. The second name is known as the failover partner name.

There is another forum for Mirroring, ask your question there to get better responses: http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/threadshttp://www.rad.pasfu.com