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
- aka Orso Bianco -
KeiichiKun
Enthusiast
 
Posts: 30
Liked: 5 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: 466
Liked: 57 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
- aka Orso Bianco -
KeiichiKun
Enthusiast
 
Posts: 30
Liked: 5 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: 466
Liked: 57 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
- aka Orso Bianco -
KeiichiKun
Enthusiast
 
Posts: 30
Liked: 5 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: 21442
Liked: 2361 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: tommyo and 52 guests