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:
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??