January 19, 2006 at 4:57 pm
Does anyone know where in Cluster Administrator you can configure the sequence for the disk startups when you're rebooting a cluster. I heard somewhere that if you have the data disk start before the log disk, the database becomes corrupt or unavailable for a very brief moment. To avoid this, I'm told to configure the disks so the log becomes available first, then data.
Can someone point me in the right direction?
many thanks
January 19, 2006 at 7:30 pm
You can set dependencies on the resources themselves. So you could set the disk resource where the logs reside where it depends on the disk resource where the database resides. If you check properties for the resource in question you'll find the dependencies tab.
However, SQL Server should be dependent on BOTH disk resources. It shouldn't have been able to deploy a database file to a disk unless said disk is a dependency of the SQL Server resource. If that's the case, then SQL Server isn't going to start up until both disk resources come on-line and this should eliminate any corruption issues.
K. Brian Kelley
@kbriankelley
January 20, 2006 at 8:52 am
Thank you Brian
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply