Comprehensive data protection for all workloads
Post Reply
KeiichiKun
Enthusiast
Posts: 97
Liked: 17 times
Joined: Jul 21, 2016 3:59 pm
Contact:

Sql Server restore takes too long?

Post by KeiichiKun »

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
DGrinev
Veteran
Posts: 1943
Liked: 247 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: Sql Server restore takes too long?

Post by DGrinev »

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!
KeiichiKun
Enthusiast
Posts: 97
Liked: 17 times
Joined: Jul 21, 2016 3:59 pm
Contact:

Re: Sql Server restore takes too long?

Post by KeiichiKun »

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
DGrinev
Veteran
Posts: 1943
Liked: 247 times
Joined: Dec 01, 2016 3:49 pm
Full Name: Dmitry Grinev
Location: St.Petersburg
Contact:

Re: Sql Server restore takes too long?

Post by DGrinev »

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!
KeiichiKun
Enthusiast
Posts: 97
Liked: 17 times
Joined: Jul 21, 2016 3:59 pm
Contact:

Re: Sql Server restore takes too long?

Post by KeiichiKun » 2 people like this post

There was a network problem that has slowed down restore :(
Thanks
Gostev
Chief Product Officer
Posts: 31814
Liked: 7302 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Sql Server restore takes too long?

Post by Gostev »

Thanks for coming back with the resolution!
valentin.ciobanu
Influencer
Posts: 11
Liked: 1 time
Joined: May 09, 2016 5:49 pm
Full Name: Valentin Ciobanu
Location: Romania
Contact:

Re: Sql Server restore takes too long?

Post by valentin.ciobanu »

what kind of problem did you had ? we encounter the same long times to restore.
Mike Resseler
Product Manager
Posts: 8191
Liked: 1322 times
Joined: Feb 08, 2013 3:08 pm
Full Name: Mike Resseler
Location: Belgium
Contact:

Re: Sql Server restore takes too long?

Post by Mike Resseler »

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

Who is online

Users browsing this forum: No registered users and 52 guests