Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

When we boot SQL Server, SAN drives might not be availiable yet. Is there a way to delay SQL Server start by 1 minute? Right now we have to restart SQL Server after we boot the server.

share|improve this question
up vote 10 down vote accepted

We talked about a similar issue before here and here and what worked in that case was setting the SQL Server to be dependent on the disk drivers. You'll want to test this to make sure this works in your setup but it should do the trick.

share|improve this answer

Try these:

  • Set a service dependency on some SAN/HBA service (can be done in services.msc)
  • Change the service to "Automatic (Delayed start)" if a later OS
  • Set the service to "Manual" and trigger with a job (as per Richard's answer)
share|improve this answer

Two things come to mind.

There is a version of Windows that allows delayed starts. However, I suspect that even if you set that up, it won't be long enough. (Also, I suspect that you probably don't have that version of windows, if you're using SAN.)

One solution (although a bit hacky) would be to create a batch script that delayed for 60 seconds and then called the service to start it up:

REM delay 60 seconds
ping -n 60  
net start mssqlserver

Add that to your Startup folder in your Program Files and it should work.

share|improve this answer
Items in the Startup Folder won't trigger until someone logs into the SQL Server so this isn't a very good method for starting the SQL Server automatically. – mrdenny Aug 22 '11 at 21:14
You mean logs into Windows? That would make sense. – Richard Aug 22 '11 at 21:21
Yep, Items in the startup folder are user specific so they aren't run until the user logs into the SQL Server. – mrdenny Aug 22 '11 at 21:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.