Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Scenario - SQL Server 2008 R2 Mirrored environment - High Safety synchronous with automated failover. Witness Server is a SQL Server 2008 R2 Express Edition.

Question: Can the Witness server be used for other SQL purposes? In particular I am wondering if it is possible to complete test restores of database backups on the Witness and then run integrity checks (DBCC CHECKDB) on the restored database?

Thanks.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Yes, the witness server can do other tasks.

What you've suggested is quite useful.

share|improve this answer

Your Answer

 
discard

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.