MS SQL DB Delay on reboot.....

[poodlepumper]

Hola.

When the server (2003 Server) is rebooted, the SQL DB is not available for 5 to 7 minutes. This causes issues for an application running as a service that pulls configuration info from the DB - without the DB being available, the configuration is not available and the app goes haywire.

Thoughts?
Suggestions?
Need help!

PP

 

[mrdenny]

I've written an FAQ on setting up other services to wait until the SQL Server has started (basic service dependency) faq962-5509.

That will stop the service from going nuts at least.

However the database shouldn't take that long to start. Can you post the error log from the beginning until it says that it's ready.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com