SQL Server Performance

SQL Server can't see the new SAN storage

Discussion in 'SQL Server Clustering' started by OldTiger, Dec 10, 2004.

  1. OldTiger New Member

    All,

    I have a 2-node 2000 cluster on Win 2003 Advanced server. The SE recently added new SAN storage (5 logical names as U, V,..Y). The new drives appear in the Cluster resource. The sql server can be failed over between the 2 nodes. I can also see the drives on the current node and am able to create new folders/files. But, the SQL Server can not see those new drives. What could be the problem?

    Thanks for any response.
    OldTiger
  2. satya Moderator

    http://www.sql-server-performance.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=1773 for reference.

    HTH

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. OldTiger New Member

    Yes, saw that link and found out that my new drives were not in the Dependant drives. But I am not able to add it to the SQL Server resource because it wanted the sql server to be offline. Could you please show the steps to ebale the new drives?

    thanks a lot,
    OldTiger
  4. satya Moderator

    Have you refreshed the SQL Server services after the addition on Cluster resouce?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. OldTiger New Member

    the new drives were on the cluster resource (but were not added to sql server resource depandency). both nodes were bounced and even the sql server was restarted. Now that we know the problem (new drives not added to sql server resource depandency), the remaining problem is on the steps to enable them for sql server.

    thanks,
    OldTiger
  6. Argyle New Member

    - Move the disks into the sql server cluster group and bring them online
    - Take the sql service offline in the group
    - Add the drives as dependencies
    - Take the sql service online in the group

    SQL Server should now be able to see the disks. Make sure that the SQL Server Service and Agent accounts have administrator permissions in any folders it will be using for databases. The accounts also need "List Folder Contents" permission on the root level of the new drives.

Share This Page