none
SQL Instances Storage

    Question

  • Hi,

    Can a single SAN storage backup LUN (drive) be shared/used by multiple SQL instances at the same time? I am assumming that the storage drive needs to be a cluster resource for each SQL group in order for each instance to see and use it? Is this correct? Can one drive be a resource for multiple resources groups?

    Thanks in Advance.

    David

    Tuesday, March 22, 2011 8:50 AM

All replies

  • Hi David, 

    Answer is No . One drive cannot be a resource for multiple resources. 

    Ex: Drive E is mapped to the cluster, then on Drive E SQL will get installed say Inst1. If we want to install a 2nd instance then we need a new drive letter. E drive will not be shown in the list of available resources as its already holding one. 

    ----------------------------
    Thanks,Suhas V  

    Tuesday, March 22, 2011 9:22 AM
  • Hi Suhas V,

    If each multiple instance in a cluster is installed using separate drive letters, can each multiple instance use a single backup drive for their backups?

    E.G. inst 01 - E for data, F for Logs and G for Backup, Can instance 02, 03,04 etc use G as their backup drive as well but use separate drives for their data and logs? Is there any issue with disk contention and access locking?

     

    Thanks,

    David

    Tuesday, March 22, 2011 9:35 AM
  • You can have a common backup drive . But the drive which is residing should be NAS share but not on the cluster . 

    ----------------------
    Thanks,Suhas V  

     

    Tuesday, March 22, 2011 9:47 AM
  • Hi David,

    "

    If each multiple instance in a cluster is installed using separate drive letters, can each multiple instance use a single backup drive for their backups?

    E.G. inst 01 - E for data, F for Logs and G for Backup, Can instance 02, 03,04 etc use G as their backup drive as well but use separate drives for their data and logs? Is there any issue with disk contention and access locking?

    "

    Yes you can have all the backups to the same drive

    We can have a common storage for backups. This can be a clustered resource or be a NAS share out of the cluster. Configur this as a backup device from all sql instences and you can backup the database to this share.

    The issue with having the storage / Share on the clusters is, the storage will be read as \\computername\path. So if the failover occurs then the computer name fails and the backup will fail with OS error path not found.

    Hence, if you want backups to be taken on SAN storage, Configure a NAS/CIFS sahre and in the backup script point the path to this share. Let this share be out of cluster.

    DN


    • Proposed as answer by nitindittakavi Saturday, June 18, 2011 6:40 PM
    Tuesday, March 22, 2011 10:13 AM