MSSQL How to backup transaction log during differential backup?

Last post 08-09-2016, 4:28 PM by tcottrell. 1 replies.
Sort Posts: Previous Next
  • MSSQL How to backup transaction log during differential backup?
    Posted: 08-09-2016, 11:12 AM
    Is possible to backup transaction log during running differential backup? Native tool can do this from version 2005.

    Thx for response.
  • Re: MSSQL How to backup transaction log during differential backup?
    Posted: 08-09-2016, 4:28 PM

    Yes.  A transaction log backup can run at the same time as full and/or differential backups. You can not run full and differential backups concurrently though.  One thing to watch out for, though, is running a subclient that has databases in SIMPLE recovery model.  Databases in SIMPLE recovery model can NOT run transaction log backups and will convert to differential.  Either filter those databases out of the subclient into their own without transaction log backups scheduled, or use an additional setting to skip them from converting:

    http://documentation.commvault.com/commvault/v11/article?p=products/sql/t_sql_db_cnv_lgbckp.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.
Close
Copyright © 2019 Commvault | All Rights Reserved. | Legal | Privacy Policy