Today I faced a situation where new LUN’s where added to a server and SQL was clustered on top of windows cluster.
I wanted to use the new LUN’s to accommodate database files and I noticed that these LUN’s needs to be added as a dependency for SQL Server Resource.
A possible downtime was on my mind, however in SQL server 2008 cluster the SQL resource will still allow you to add disks as dependency without we taking it offline. This is indeed an awesome feature and it was missing in SQL 2005.
I just love the way SQL Server is improving version – version.