-
- Enthusiast
- Posts: 97
- Liked: 17 times
- Joined: Jul 21, 2016 3:59 pm
- Contact:
Sql Server restore takes too long?
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
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
-
- 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?
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!
Can you share more information about infrastructure and the version of Veeam you are using.
Also, what kind of restore did you choose? Thanks!
-
- Enthusiast
- Posts: 97
- Liked: 17 times
- Joined: Jul 21, 2016 3:59 pm
- Contact:
Re: Sql Server restore takes too long?
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
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
-
- 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?
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!
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!
-
- Enthusiast
- Posts: 97
- Liked: 17 times
- Joined: Jul 21, 2016 3:59 pm
- Contact:
Re: Sql Server restore takes too long?
There was a network problem that has slowed down restore
Thanks
Thanks
-
- 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?
Thanks for coming back with the resolution!
-
- 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?
what kind of problem did you had ? we encounter the same long times to restore.
-
- 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?
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
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
Who is online
Users browsing this forum: Bing [Bot], Jacksharkben, Semrush [Bot] and 37 guests