Solved

Block Level Backup Options-Optimize for Table Level Restore.

  • 16 February 2023
  • 5 replies
  • 212 views

Userlevel 1
Badge +8

Dear Sirs, please help me: In SQL databases more exactly in Properties-Advanced Options- Block Level Backup Options-Optimize for Table Level Restore.
Does this option work for backups that are on tape or does it only apply to disk? What is the impact of activating this option?

Thank For Your Help.


(attached image)

 

icon

Best answer by Scott Reynolds 20 February 2023, 14:57

View original

5 replies

Userlevel 6
Badge +14

Hello @FeRox 

No it is not supported for tape/virtual libraries.

When this option is enabled full databases backups will leverage VSS to perform the backup. It does allow table level recovery and in some situations like Sharepoint mining it makes sense but in general there is no reason to enable this unless you have those two above requirements. More info is listed here:

https://documentation.commvault.com/2022e/expert/18230_performing_block_level_backup_operation_on_sql_databases.html

Userlevel 1
Badge +8

Dear friends, I have another question, why when the block level is activated, the backups are executed by a single stream, and this is already a problem because it degrades the speed of the backups.

Userlevel 6
Badge +14

@FeRox Correct that is expected as block-level backups leverage VSS which is restricted to 1 stream.

Userlevel 1
Badge +8

Does this happen in all commvault versions, as this degrades the transfer speed too much.

Userlevel 6
Badge +14

@FeRox Yes it would apply to all versions.

Believe the limitations here is the VSS writer

https://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/sql-server-vss-writer-backup-guide?view=sql-server-ver16

Reply