SQL Simple and Full Recovery databases in the one subclient?

Last post 09-30-2020, 3:45 AM by stefan.vollrath. 1 replies.
Sort Posts: Previous Next
  • SQL Simple and Full Recovery databases in the one subclient?
    Posted: 09-30-2020, 12:18 AM

    Hi Folk,

    Just starting to setup some SQL clients, and wondering if the Simple and FULL databases should be in seperated subclients?  


    It seems that CommVault can handle them being in the same subclient, even if you do logs only at intervals, but does that cause problems down the path?


    We're on V11.20 




  • Re: SQL Simple and Full Recovery databases in the one subclient?
    Posted: 09-30-2020, 3:45 AM

    Hi Stuart

    Depends on your needs. For simplicity and making most of auto-detection keep everything in default subclient, for better control split it appart either manually or by utilizing the Subclient Type Setting (General Tab of Subclient Porperties).

    Personally I left most of it in default and used AdditionalSettings bSkipTLForSimpleRecoveryModelDB, bSkipTLForReadOnlyDB & bSkipDiffReadOnlyDB to reduce the amount of unneeded conversions to Full-Backups. Only if some DB needs special Retention or more frequent schedule I moved it to separate Subclient.

    Hope that helps,


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