Host-based backup of VMware vSphere VMs.
Post Reply
CKESSLER
Enthusiast
Posts: 31
Liked: 4 times
Joined: Dec 25, 2015 9:44 am
Contact:

SQL - Optimize Restore Times (only Changed Data?)

Post by 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
Product Manager
Posts: 14287
Liked: 2877 times
Joined: Sep 01, 2014 11:46 am
Full Name: Hannes Kasparick
Location: Austria
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by 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
Enthusiast
Posts: 31
Liked: 4 times
Joined: Dec 25, 2015 9:44 am
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by CKESSLER »

Ok, thank you for your Feedback
Gostev
Chief Product Officer
Posts: 31456
Liked: 6647 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by Gostev »

CKESSLER wrote: May 06, 2019 7:20 amIn our environment the restore of this 300 GB database takes about 2 hour.
What Veeam version are you using?
CKESSLER
Enthusiast
Posts: 31
Liked: 4 times
Joined: Dec 25, 2015 9:44 am
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by CKESSLER »

Dear Gostev,
Sorry for my late reply. We are using 9.5 Update 4
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by veremin »

In this case reach our support team and let them find the component that slows down db restore. Thanks!
r0bbienz
Influencer
Posts: 10
Liked: 2 times
Joined: Nov 06, 2018 12:21 am
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by r0bbienz »

CKESSLER wrote: Jun 17, 2019 5:57 am Dear Gostev,
Sorry for my late reply. We are using 9.5 Update 4
Hey did support solve your slow problem?
veremin
Product Manager
Posts: 20270
Liked: 2252 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: SQL - Optimize Restore Times (only Changed Data?)

Post by 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!
Post Reply

Who is online

Users browsing this forum: No registered users and 83 guests