I have at least 100 restore jobs, the pre-drop gonna help big time, thanks Andrew.

Cheers

Hello Steve,

Thanks for the great script, I use it on a daily schedule for various restore jobs but found a issue not sure its something to do with my logic...

Hi,

I had the same issue, all my error log was with the message:

starting up databases xxx checkdb for database xxx finished without errors

Below forum has helped me:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/61492307-1849-4a07-ad80-0499a5e5425f/checkdb-running-constatly?forum=sqldatabaseengine

Just set...

The problem here is the backup file was locked, we need to close the file.

Steps to close the file:

Computer Management-->>System Tools-->Shared Folders-->>Open Files-->(here we can see our back up file)-->>right...