SQL Server won’t start due to LUNs being unavailable

sql-server-2005

I've got a standalone SQL 2005 server (on Windows Server 2003) which has 2 LUN drives attached for the datafiles and transaction logs.

When the server reboots, the SQL Server service starts before the LUN drives are available and therefore errors and creates new logfiles on another drive.

I've read some articles, such as this one:

SQL Dev article

that show you how to do it using Cluster Manager but my box isn't clustered. Does anyone know how to set this dependency up??

Best Answer

I'm not sure if this will work or not, as I don't have a machine with the same problem, but you can configure the SQL Server service to not start until the disk driver reports that it is online.

I talk about setting this registry key in this FAQ. The disk drivers are called "Disk". If this doesn't work you'll want to remove the setting from the registry.

Related Topic