Discussions specific to the VMware vSphere hypervisor
Post Reply
CKESSLER
Influencer
Posts: 14
Liked: 1 time
Joined: Dec 25, 2015 9:44 am
Contact:

SQL - Optimize Restore Times (only Changed Data?)

Post by CKESSLER » May 06, 2019 7:20 am

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
Veeam Software
Posts: 3991
Liked: 487 times
Joined: Sep 01, 2014 11:46 am
Location: Austria
Contact:

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

Post by HannesK » May 06, 2019 9:21 am

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

Best regards,
Hannes

CKESSLER
Influencer
Posts: 14
Liked: 1 time
Joined: Dec 25, 2015 9:44 am
Contact:

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

Post by CKESSLER » May 06, 2019 10:51 am

Ok, thank you for your Feedback

Gostev
SVP, Product Management
Posts: 24787
Liked: 3520 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

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

Post by Gostev » May 06, 2019 4:28 pm

CKESSLER wrote:
May 06, 2019 7:20 am
In our environment the restore of this 300 GB database takes about 2 hour.
What Veeam version are you using?

CKESSLER
Influencer
Posts: 14
Liked: 1 time
Joined: Dec 25, 2015 9:44 am
Contact:

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

Post by CKESSLER » Jun 17, 2019 5:57 am

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

veremin
Product Manager
Posts: 16880
Liked: 1430 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » Jun 17, 2019 6:07 pm

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 » Jun 24, 2019 4:58 am

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: 16880
Liked: 1430 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

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

Post by veremin » Jun 24, 2019 2:07 pm

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: Bing [Bot], DavoudTeimouri and 28 guests