|
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.
(comments are locked)
|
|
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)
(comments are locked)
|
Your answer
