MSSQL Backup from Secondary Replica on Availability Group

Last post 05-13-2020, 8:30 PM by ddwyer. 1 replies.
Sort Posts: Previous Next
  • MSSQL Backup from Secondary Replica on Availability Group
    Posted: 03-04-2020, 7:12 AM

    Hi,

     

    Is there a way to force to take backup MSSQL DB in Availability Group on Secondary Replica? The customer is choosing Secondary Replica on Backup Preferences but the Commvault still taking backup on Primary Replica. 

     

    Best Regards.

  • Re: MSSQL Backup from Secondary Replica on Availability Group
    Posted: 05-13-2020, 8:30 PM

    Hi,

    Apologies for the delayed response. The AG backup will run on secondary for transaction log backup or copy only full backup by default, if you are  attempting to run full or differential backup these will run on the primary replica, as these backup types are not supported on secondary in SQL Server. 

    This is mentioned in BOL: http://documentation.commvault.com/commvault/v11_sp18/article?p=18295.htm

    Notes:

    • Full and differential backups always run on the primary replica.
    • Full copy only and transaction log backups run either on the primary replica, if the primary replica is set as the preferred replica for running backups, or on the secondary replica with the highest backup priority.

     

    The backup preference here can also not be controlled by Commvault, so if customer is seeing backup run on primary replica, they have not set the AG to use "Secondary only" preference in SQL Server. Note once again, that if the goal here is to run all backup on secondary then the full backup must be scheduled to use the copy-only advanced option.

    David

The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Close
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy