MS SQL Server - SQL Server 2K recovery test...

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL Server 2K recovery test...

Lowry Smith

2006-10-24, 6:33 pm

I have tested the complete recovery of SQL Server installation. Ie. Master,
MSDB and user databases. I do not store any data in Model database.

After restoring the Master and MSDB I can see the Job list, DTS packages,
User list etc in their respective nodes.

I assume that the restore is successful.

Is there any way or methodologies for SQL DBA to tell that the restore is
100% perfect. I have read some documentation on test scripts which will run
against the restored databases. What is this test script?

Any thought on this is really appreciated.

Smith

Sponsored Links