Post reply

Can we backup a DB from SQL Server 2012 two node cluster to a local disk ?

  • May 12, 2015 at 2:11 am

    #297968

    Hi,

    Can we backup a DB from SQL Server 2012 (Ent. edition) two node cluster to a local disk ?. Is it possible ?

    Thanks,

    San.

  • May 12, 2015 at 2:33 am

    #1797170

    Backing up to a local disk is a terrible idea. Why do you think you need to do that?

    -- Gianluca Sartori

  • May 12, 2015 at 2:49 am

    #1797174

    Thanks...

    ... was just thinking as SAN disks are very expensive..

    ..just checking if we can save any money by doing this..

  • May 12, 2015 at 2:52 am

    #1797176

    Trust me: losing backups is much more expensive than SAN disks.

    If you back up your SQL Server to the same machine where the server runs and the server fails, you lose everything.

    -- Gianluca Sartori

  • May 12, 2015 at 2:53 am

    #1797177

    No. A clustered SQL instance can only see shared drives that are added as dependencies of the SQL Service.

    And if you back up to the local drive, what happens when there's a problem with that server? Bye bye databases and their backups. Backups should be stored separately to the server.

    Oh, and if you think SAN drives are expensive, see how expensive losing the entire DB is.

    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

  • May 12, 2015 at 3:00 am

    #1797180

    Thanks Gianluca Sartori and Gila.

    No. A clustered SQL instance can only see shared drives that are added as dependencies of the SQL Service.

    Bit confused on this. There is a SQL 2008 cluster instance where they backup DBs to a local disk.

    A maintenance task has been created for the backup and for the backup path, local disk path is mentioned. (yes, its NOT visible to chose)

    Oh, and if you think SAN drives are expensive, see how expensive losing the entire DB is.

    Just checking the options. We are insisting for a shared disk for DB backups.

    Thanks.

  • May 12, 2015 at 3:15 am

    #1797184

    BTW, SAN disk can be expensive, but NAS disks are cheap. You can always take your backups to a NAS (SMB shares are getting faster and more reliable with SMB3) and have your backups in a separate place in case the whole SAN fails.

    -- Gianluca Sartori

  • May 12, 2015 at 3:20 am

    #1797189

    OK... We will explore that option... let's which one will be more suitable. Thanks !.

Viewing 8 posts - 1 through 7 (of 7 total)

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