Post reply

Backup file systems are configured in the SQL Cluster as dependencies

  • August 3, 2011 at 5:38 am

    #245525

    Hi

    on our SQL SERVER DB Servers, Backup file systems are configured in the SQL Cluster as dependencies. Recently we had a mishap,the backup file systems were lost( drive was lost) from the DB servers which resulted in the cluster shutting the instance down. Do the backup file systems really need to be in the SQL Cluster.

    Cheers

    Murali

  • August 3, 2011 at 6:29 am

    #1362972

    edit: see below

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • August 4, 2011 at 6:55 am

    #1363607

    the backup drive must be a dependency on the clustered sql server resource. If the disk dies replace it or temporarily remove the dependency.

    The loss of one disk shouldn't cause the array to die completely, what disk configuration are you using?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • August 4, 2011 at 7:23 am

    #1363630

    murali.jillellamudi 85871 (8/3/2011)

    Do the backup file systems really need to be in the SQL Cluster.

    Yes, because otherwise SQL can't write a backup to them. All drives used by SQL (backups and data/log file locations) must be configured as dependencies of the SQL resource group in cluster admin.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply