none
SQL Server backups and mirror backup files. RRS feed

  • Question

  • Hi,

    Currently, I am using, REDGATE backup and it supports, mirroring backup files to the network folders

    SQL Server T-SQL also supports backup with mirroring, I don't see mirror option in SSMS-->Maintenance Plan, Is I am missing something here, or Maintenance Plan does not support backup mirrors. Please confirm.

    BACKUP DATABASE AdventureWorks 

    TO DISK = 'C:\Backup\AdventureWorksL1.bak' 

    MIRROR TO DISK = 'C:\Backup\AdventureWorksM1.bak' 
    WITH FORMAT

     



    • Edited by Sivakumar.In Wednesday, November 27, 2019 9:22 AM
    Wednesday, November 27, 2019 9:20 AM

Answers

All replies

  • Those tools do not support mirroring of backup files. Ola Hallengren's procedures does, however: https://ola.hallengren.com/

    Note that mirroring is fragile in the sense that if one destination isn't available, then everything will fail (SQL Server will not produce the backup to the "healthy" destination only).


    Tibor Karaszi, SQL Server MVP (Web Blog)

    • Proposed as answer by KevinBHill Wednesday, November 27, 2019 2:03 PM
    Wednesday, November 27, 2019 10:55 AM
  • Thanks
    • Marked as answer by Sivakumar.In Wednesday, November 27, 2019 2:01 PM
    Wednesday, November 27, 2019 2:01 PM