SQL Block Level Backup Option

Last post 02-11-2020, 8:55 AM by Kris!. 2 replies.
Sort Posts: Previous Next
  • SQL Block Level Backup Option
    Posted: 02-07-2020, 2:55 PM

    So it was recommended to me to NOT do block level SQL backups if table level restores are not needed.


    What's the reason for this?


    Are there obvious drawbacks or does it cause issues with the backups/restores?


    Thanks in advance.


  • Re: SQL Block Level Backup Option
    Posted: 02-07-2020, 3:43 PM
    • Aplynx is not online. Last active: 08-13-2020, 3:38 PM Liam
    • Top 10 Contributor
    • Joined on 05-04-2010
    • New Jersey
    • Master
    • Points 1,871

    You need double the size of the database for backups and restores are going to be very slow. 

  • Re: SQL Block Level Backup Option
    Posted: 02-11-2020, 8:55 AM

    The problem is some of the restores quit progressing on larger DB's.

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