2

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.

1

Yes, the witness server can do other tasks.

What you've suggested is quite useful.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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