Post reply

Backup on shared drive failing

  • July 24, 2014 at 11:29 am

    #293693

    Hi,

    I have a 4 node cluster with 6 instances.

    Lets said my 4 nodes are named as Node A, Node B, Node C and Node D

    my instances are called Inst1, Inst2, Inst3, Inst4, Inst5 and Inst6

    I am trying to take a backup of a database on Inst3 to a disk not mapped to the instance in the cluster.

    Backup database productiondb to disk = '\\XXXXXXX\SQLbackups' shared folder and I end up getting an error.

    what could be the reason. Can I work this out?

  • July 24, 2014 at 11:45 am

    #1732164

    Benki Chendu (7/24/2014)

    I am trying to take a backup of a database on Inst3 to a disk not mapped to the instance in the cluster.

    And that (the bolded part) is your problem.

    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

  • July 24, 2014 at 12:42 pm

    #1732177

    Does your service account (for the instances) have rights to this folder?

  • July 24, 2014 at 2:56 pm

    #1732208

    GilaMonster (7/24/2014)

    Benki Chendu (7/24/2014)

    I am trying to take a backup of a database on Inst3 to a disk not mapped to the instance in the cluster.

    And that (the bolded part) is your problem.

    Thanks Gila. But why is the backup not happening to the shared location as I had mentioned above..

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

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