SQL - Optimize Restore Times (only Changed Data?)

[CKESSLER]

Dear Community,

I have a question regarding possible restore scenarios with VBR.

My MS SQL servers are backed up with VBR.
Databases have about a size of about 300GB.

From time to time we update our application, and therefore also the corresponding database.
Before the update I usually backup the SQL Server with Veeam.
In case of a problem during update, I restore the single database from the last Veeam backup.

In our environment the restore of this 300 GB database takes about 2 hour.

Is there any way to optimize the restore times without changing the infrastructure?
Maybe there is a way that Veeam only restores blocks of the database which have been changed since the last backup? (Differencial)

Thank you,
Chris

[HannesK]

Hello,
unfortunately Veeam don't support block based SQL database restore today. We count that as a +1 feature request.

Best regards,
Hannes

[CKESSLER]

Ok, thank you for your Feedback

[Gostev]

In our environment the restore of this 300 GB database takes about 2 hour.

What Veeam version are you using?

[CKESSLER]

Dear Gostev,
Sorry for my late reply. We are using 9.5 Update 4

[veremin]

In this case reach our support team and let them find the component that slows down db restore. Thanks!

[r0bbienz]

Dear Gostev,
Sorry for my late reply. We are using 9.5 Update 4

Hey did support solve your slow problem?

[veremin]

Are you struggling with the same issue? If so, have you reached our support team and let them find the weakest link (in terms of performance) in the backup chain? Thanks!