Skip to main content
Solved

Block Level Backup Options-Optimize for Table Level Restore.

  • February 23, 2023
  • 3 replies
  • 147 views

FeRox
Novice
Forum|alt.badge.img+7


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

Best answer by Scott Reynolds

Hello @FeRox 
Correct I responded on the other thread.


Yes it would apply to all versions.Single Stream when enabled.

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

3 replies

Forum|alt.badge.img+13

Hi @FeRox 

 

Which agent are you using for block level backups ?

 

Regards,

Gowri Shankar


FeRox
Novice
Forum|alt.badge.img+7
  • Author
  • Novice
  • February 23, 2023

Hi @Gowri Shankar I am using SQL Server


Forum|alt.badge.img+14

Hello @FeRox 
Correct I responded on the other thread.


Yes it would apply to all versions.Single Stream when enabled.

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