Mirror Backup Success

  • As I would like to know in Mirroring..Will mirror backup succeed if one of the mirror location fails/become unavailable. Please clarify me on this.

  • What do you mean by 'mirror backup'?

    If you mean, \BACKUP DATABASE... TO DISK ... MIRROR TO ... then that has nothing whatsoever to do with database mirroring.

    If you do mean the MIRROR TO clause of backup database, then all specified locations must exist and be accessible or the backup will fail.

    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 2 posts - 1 through 2 (of 2 total)

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