SQL Server Performance

Specifying file locations in clustered SQL server

Discussion in 'SQL Server Clustering' started by ericoo, Dec 6, 2006.

  1. ericoo New Member

    I have SQL2005 clustered on windows 2003 servers. I have two physical disks/LUNS in same cluster resource group which I intended to use one for data and one for log files. The problem is after installing SQL 2005 on one of the drive, SQL server doesn't reconize another drive in the same cluster resource. So, I do not have the option to specify where the log file should go for new database. How do I make SQL server to see another drive? Currently it only sees the drive that it was installed on.
  2. satya Moderator

    http://www.sql-server-performance.com/q&a_clustering.asp fyi.

    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
  3. bradmcgehee New Member

    Be sure that the other drive (the one SQL Server can't see) has been setup as a cluster resource in Cluster Administrator.

    Brad M. McGehee, SQL Server MVP
  4. ericoo New Member

    The drive that SQL server can't see is setup using cluster administrator. From the ClusterAdministrator windows, I can see the drive, but SQL can't see it from SQL server management studio.
  5. MohammedU New Member

    Check after a server restrt...

    Mohammed U.
  6. catullus Member

    Does the SQL server resource have a dependency on the disk resource?
  7. Anil New Member

Share This Page