Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

2 Answers 2

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.