July 18, 2011 at 9:07 am
Hi all,
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??
Thanks,
Rich.
July 18, 2011 at 9:45 am
I'm not sure, but would you not need to create a single-node cluster (it's allowed! See here) in order to be able to create the dependency within Cluster Administrator?
Adrian Nichols
Many Thoughts in a Storm
www.adriannichols.com
July 18, 2011 at 9:47 am
Just change to delayed start in services.msc. Or, for a more complex solution, disable the SQL services and write a batch that starts the services in correct order after looking to see if the drives are there. Start the batch up using a schedule task at startup.
Adrian, I wouldn't add complexity of clustering a single node. Also, never answer a post by starting a reply with "I'm not sure". :hehe:
July 18, 2011 at 9:54 am
Vincent, thanks for the comments I will be more certain before I craft my reply next time!
I understand that this is not a cluster at the moment; I thought that if it was made in to a single node cluster, it would resolve the current issue and allow for future scalability.
Adrian Nichols
Many Thoughts in a Storm
www.adriannichols.com
July 18, 2011 at 9:57 am
Just a slight variation of the was suggested; I would disable the services, restart and start each service in the correct order.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 18, 2011 at 10:08 am
don't disable the services, set them to manual startup and then use 'NET START' command to start the services. Incidentally, why is it taking so long for the storage to come online, what type of storage setup are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 10:25 am
Hi,
Thanks for the suggestions so far.
I don't know (yet) why the LUNs are taking so long to come online. From what I've noticed, none of the other servers that we use this configuration on don't show this "feature".
We're using NetApp filers using iSCSI for our storage.
Rich.
July 18, 2011 at 10:35 am
Can't you call Netapp for technical support?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
July 18, 2011 at 10:35 am
Could you provide more info on the iSCSI setup
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 18, 2011 at 10:43 am
Sure, what sort of thing do you want to know??
I had thought, after further reading, that it could be because the disks were dynamic, as per:
but i've checked in Computer Management - Disk Management and they're Basic (or at least I assume they are as a right-click gives the option to "Convery to Dynamic Disk").
Rich.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply