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.
3 Answers
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)
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 127.0.0.1 -n 60
net start mssqlserver
Add that to your Startup folder in your Program Files and it should work.
-
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.– mrdennyAug 22, 2011 at 21:14
-
-
Yep, Items in the startup folder are user specific so they aren't run until the user logs into the SQL Server.– mrdennyAug 22, 2011 at 21:23