Monday, April 30, 2012 3:42 PM
I have a clustered SQL Server 2008 Server with a log drive mount points as F:\logdrive1, F:\logdrive2 and F:.
The dependency has been defined as below and in SQL Server cluster Group -
F: <= F:\logdrive1
F: <= F:\logdrive2
SQL Server <= F:\logdrive1
SQL Server <= F:\logdrive2
There is an existing log file in F:\logdrive1. When I add an extra file on F:\logdrive2 I get an error.
ALTER DATABASE [db]
ADD LOG FILE ( NAME = N'db',
FILENAME = N'F:\Logdrive2\db_log_3.LDF' , SIZE = 1024MB , FILEGROWTH = 10%)
Msg 5184, Level 16, State 2, Line 1
Cannot use file 'F:\logdrive2\db_log_3.LDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. Either the disk resource containing the file is not present in the cluster group or the cluster resource of the Sql Server does not have a dependency on it.
Msg 5009, Level 16, State 8, Line 1
One or more files listed in the statement could not be found or could not be initialized.
I mean this doenot make sense I have the dependency in place and still it gives error. I have other ldf files from other database in the same drive from same instance.
Monday, April 30, 2012 3:47 PM
We don't you make the F drive as a whole a SQL Server dependency?
Also, you only need one log file for a database. Multiple data files can improve performance but not log files as SQL writes to them sequentially.
- Marked As Answer by Shiju Samuel Monday, April 30, 2012 11:59 PM