I just started a new job and have been given the SQL DBA duties (new to our environment) as our other DBAs are Oracle.
We have SQL Server 2008 R2 on a cluster.
I noticed that the data and log files were being stored in the same drive and folder (E:) so I decided to separate them and had a new drive created on the cluster (L:).
My question is that when I went to change the location of the log files the new drive letter does not show up. If I click File, Open, it shows up, but not if I browse or even try to create a new database.
asked Oct 19 '11 at 09:46 AM in Default
When you added the new drive to the cluster you have to be sure to add it as a dependency for SQL Server in order for SQL to recognize it correctly (I would also confirm that the disk is in the same cluster group)
answered Oct 19 '11 at 09:50 AM