Log file in Clustered SQL Server

Question

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.

USE [master]
GO
ALTER DATABASE [db]
ADD LOG FILE ( NAME = N'db',
FILENAME = N'F:\Logdrive2\db_log_3.LDF' , SIZE = 1024MB , FILEGROWTH = 10%)
GO

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.

Answer 1

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.

Seth

---

http://lqqsql.wordpress.com