Sql Server restore takes too long?

Availability for the Always-On Enterprise

Sql Server restore takes too long?

Veeam Logoby KeiichiKun » Tue Aug 29, 2017 9:10 am

Hi all,
I've done a restore of a database (about 6.5Gb).
It takes about 5 hours to complete over a 1gbps network.
Is that normal?
Thanks
KeiichiKun
Enthusiast
 
Posts: 51
Liked: 9 times
Joined: Thu Jul 21, 2016 3:59 pm

Re: Sql Server restore takes too long?

Veeam Logoby DGrinev » Tue Aug 29, 2017 11:56 am

Hi,

Can you share more information about infrastructure and the version of Veeam you are using.
Also, what kind of restore did you choose? Thanks!
DGrinev
Veeam Software
 
Posts: 1036
Liked: 109 times
Joined: Thu Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev

Re: Sql Server restore takes too long?

Veeam Logoby KeiichiKun » Tue Aug 29, 2017 1:12 pm

Hi,
Veeam 9.5U2, restoring from a vm to another vm on the same cluster, using a nas as repository for backup (connected to the same switch virtual infrastructure is connected).
We choose "restore state to" option, so full restore in place from latest backup
KeiichiKun
Enthusiast
 
Posts: 51
Liked: 9 times
Joined: Thu Jul 21, 2016 3:59 pm

Re: Sql Server restore takes too long?

Veeam Logoby DGrinev » Wed Aug 30, 2017 12:52 pm

Hi,

Please can you try to upload any file (about 6 - 10 GB) from the NAS to the datastore hosting your SQL server and share the stats of the performance.
This would help us to understand where the potential issue is. Thanks!
DGrinev
Veeam Software
 
Posts: 1036
Liked: 109 times
Joined: Thu Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev

Re: Sql Server restore takes too long?

Veeam Logoby KeiichiKun » Thu Aug 31, 2017 1:00 pm 2 people like this post

There was a network problem that has slowed down restore :(
Thanks
KeiichiKun
Enthusiast
 
Posts: 51
Liked: 9 times
Joined: Thu Jul 21, 2016 3:59 pm

Re: Sql Server restore takes too long?

Veeam Logoby Gostev » Sun Sep 03, 2017 8:08 pm

Thanks for coming back with the resolution!
Gostev
Veeam Software
 
Posts: 22404
Liked: 2677 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: Sql Server restore takes too long?

Veeam Logoby valentin.ciobanu » Thu Feb 08, 2018 2:43 pm

what kind of problem did you had ? we encounter the same long times to restore.
valentin.ciobanu
Novice
 
Posts: 5
Liked: 1 time
Joined: Mon May 09, 2016 5:49 pm
Location: Romania
Full Name: Valentin Ciobanu

Re: Sql Server restore takes too long?

Veeam Logoby Mike Resseler » Fri Feb 09, 2018 6:46 am

Valentin,

The OP had a network issue. You can do the test that Dmitry said above and see if it is a network issue. If not, feel free to open a support case and add the support case ID and follow-up here
Thanks
Mike
Mike Resseler
Veeam Software
 
Posts: 4273
Liked: 480 times
Joined: Fri Feb 08, 2013 3:08 pm
Location: Belgium, the land of the fries, the beer, the chocolate and the diamonds...
Full Name: Mike Resseler


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: Bing [Bot] and 24 guests