SQL Server Performance

SQL Server Cluster and drives

Discussion in 'SQL Server Clustering' started by parallel, Oct 29, 2004.

  1. parallel New Member

    I have built an active/active cluster with sevral drives, E: data, F: data, L: log, when I installed sql server I specified the data file to be on E: drive. when I try to create a database it only give me the choice of data file and log file to be created on the E: drive. What I want is the ability to create the datafiles on E: and Log file on L:, how can I do that?
    another question:

    I need to failover to the other node when SQL server or SQL server agent fails, how I can do that?

    Thanx
  2. bradmcgehee New Member

    Are the drives part of the SQL Server resource group? All drives with any SQL Server data at all needs to be in the same resource group as the SQL Server services.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  3. parallel New Member

    Yes they are.
  4. bradmcgehee New Member

    I have seen the problem you have described on one of my servers. What I had to do was to manually enter the path I wanted, instead of just browsing for it. This seemed to fix the problem I had.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com
  5. parallel New Member

    I have fixed the problem by adding the drives to the dependency of SQL server in the cluster.

    I still have to try and figure how to failove when sql server agent fails.

    Thanx Brad for you intrest.
  6. Argyle New Member

    Yes you need to add all disks to the dependency list of the SQL Server resource. During install only the Data disk will be added by default. The install does not know if you have additional disks.

    About SQL Server Agent, as long as the resource is set to "Affect group" under the Properties->Advanced tab, the group will failover if SQL Server Agent fail.
  7. bradmcgehee New Member

    I forgot about the dependency issue. Yes, I ran into that issue also, but had forgotten about it.

    -----------------------------
    Brad M. McGehee, MVP
    Webmaster
    SQL-Server-Performance.Com

Share This Page