SQL Server Performance

How to backup a clustered drive to tape?

Discussion in 'SQL Server 2005 Clustering' started by DBADave, Jan 11, 2008.

  1. DBADave New Member

    We want to backup our SQL Server backup files to tape nightly. Do I need to create a shared cluster resource in order to backup a drive to tape? I was told that creating a clustered resource share name would allow us to automatically failover a share and therefore not require manual intervention to tell our backup software, ArcServe, that our network name is no longer the name of the primary node. If we use clustered share names when we define backups, the share name will automatically failover and our backup software will continue to function. Is this correct?
    Thanks, Dave
  2. MohammedU New Member

    Add backup disk added to cluster shared resoure so that the failover should not cause tape backup to fail becuase it goes based on virtual server name not the node name.
  3. DBADave New Member

    Let's see if I understand.
    Physical Server Names: SQLNode1 & SQLNode2
    Cluster Name: SQLCluster
    SQL Server Cluster Name: SQL1P
    Backup Drive Location: G Drive - G:MSSQLBackup
    Given the above information are you saying the backup software should be referencing \SQLClusterG$ ?
    Thanks, Dave

Share This Page