I have a contingency box where I am restoring all the databases from production backups. For the past two days the restore stops right after restoring the first backup with the below messages.

Starting up database 'databasename'.

Bypassing recovery for database 'databasename' because it is marked IN LOAD

Starting up database 'databasename'.

Bypassing recovery for database 'databasename' because it is marked IN LOAD

Recovery is checkpointing database 'databasename' (29)

Starting up database 'databasename'.

Database restored.

Thread creation failed. Running BACKUP/RESTORE cleanup.

---My job fails here. But when I run the same proc using Query analyser it works perfectly fine.


SQL Agent account is same as sqlserver service account which is a domain admin account. Permission is not the issue.

I will try restarting the box today.

Any ideas , suggestions, recommendations?