SQL DB backup order

Last post 08-11-2020, 7:42 AM by ddwyer. 1 replies.
Sort Posts: Previous Next
  • SQL DB backup order
    Posted: 08-05-2020, 5:28 PM

    Is there a way to ensure one or more SQL DBs is always backed up after another DB's backup finishes? For example, given DBs dataA, dataB, dataC, and dataD:

    dataA and dataC can start anytime after 8pm
    dataB must start ONLY AFTER dataA and dataC are both finished backing up
    dataD must start ONLY AFTER dataB is finished backing up

    So D is dependent on B, and B is dependent on A and C.

    The backup times will not be consistent, so I am not comfortable simply putting them in their own subclients and then scheduling each subclient hours apart. I bet this could be accomplished via workflow but I was looking for a more "native" solution.


  • Re: SQL DB backup order
    Posted: 08-11-2020, 7:42 AM

    Hi JBS,

    One thing you could check out would be SQL On-Demand subclient. It will take a list of DBs from a file and then back them up in the order provided.

    On-Demand Data Protection: https://documentation.commvault.com/commvault/v11/article?p=58754.htm

    SQL Server CLI: https://documentation.commvault.com/commvault/v11/article?p=18341.htm



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.
Copyright © 2021 Commvault | All Rights Reserved. | Legal | Privacy Policy