Restore Error

[MAK]

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?

[skhanal]

Hmmm...

Sounds like you ran out of max. worker threads in SQL Server? How many active connections you had in the contingency box?

If not this, then OS is not able to create threads. Did you see anything strange in processes tab in Task Manager?

[MAK]

5 connections.

restore process is sequential. one database after another.

Nothing strange in task manager process tab and nothing in eventlog.

I am recycling the box today, lets see what happens.



Thanks

[rmiao]

Check kb article q306457, it may help.

[MAK]

Thanks guys. I believe this is going to work.

[MAK]

1. I increased the # of worker threads
2. Increased the # of worker threads for sql agent.
3. recyled the box.

Still same issue. Any ideas?

[MAK]

Issue was resolved.

when i removed the RAISEError statement from the procedure.

Strange isn't it