Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In SQL Server 2008 R2 Express the only mirroring alternative is "Witness only", however I can't find a good explenation to what this is.

I would like to have a database on a virtual server and then have a local SQL Server that mirrors this database, in case the internet connection goes down, I want to fail-over on the local server.

Any ideas on what SQL Server editions I need to be running on both ends?

share|improve this question

migrated from superuser.com Mar 22 '11 at 13:07

This question came from our site for computer enthusiasts and power users.

For SQL 2008 you can run either Enterprise or Standard for mirroring: http://msdn.microsoft.com/en-us/library/ms188712.aspx

The witness server itself can be Standard, Enterprise, Workgroup, or Express.

The witness server is needed for automatic failover: http://technet.microsoft.com/en-us/library/ms175191.aspx

share|improve this answer

"Witness only" refers to the role that Express edition can play in a mirroring setup between higher editions.

It can not be a principal or mirror. There is no "Witness only" mirroring setup

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.