up vote 2 down vote favorite
share [g+] share [fb]

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.

link|improve this question
feedback

1 Answer

up vote 1 down vote accepted

Yes, the witness server can do other tasks.

What you've suggested is quite useful.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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