SQL restore speed

VMware specific discussions

Re: SQL restore speed

Veeam Logoby eshteinman » Wed Aug 10, 2016 8:23 am

Please write in this topic answer from technical support
Posts: 4
Liked: 2 times
Joined: Tue Dec 09, 2014 10:54 am
Full Name: Evgeny Shteynman

Re: SQL restore speed

Veeam Logoby JoshuaPostSAMC » Mon Aug 15, 2016 3:18 pm

We just ran into this same thing. Restored a 100 GB database on a VM in our UCS cluster with 10 GB networking and it took almost 3 hours to complete. I'm collecting details of how the restore was ran, but I expect it was from a remote console on the admin's workstation and trying to restore directly into the target SQL server. It really needs to be addressed so the restores can happen as fast as possible.
Posts: 116
Liked: 16 times
Joined: Thu Jul 30, 2015 7:32 pm

Re: SQL restore speed

Veeam Logoby yunales » Thu Aug 18, 2016 11:55 am

just a quick update. As requested by Vitaly I opened up a case with reference to this thread. But the case was not forwared to the Dev team. Instead I need to do some testing and upload the log bundle.

here's the answer from Roman Rakhimov:
I'm sorry to bother you.

My escalation engineer required more data to continue this case handling.

Can you please clarify, is restore with 'export' done locally or to the same target server?

Please provide us with following information:

1. Infrastructure description:
- Veeam B&R version and build number
- Backup job name used in SQL DB restore session
- Server name where console was executed for restore session
- SQL VM name
- Backup repository name where backup file is located (type of connection: NFS, iSCSI, CIFS, DAS)

2. Collect restore sessions logs:
* One bundle for 'restore to original' SQL server
* Second log bundle for 'export to another folder'

I dont understand why I must test and log everything again since it's cleary a bug! But so be it....
Posts: 14
Liked: 4 times
Joined: Wed Aug 20, 2014 7:34 pm
Full Name: P K

Re: SQL restore speed

Veeam Logoby Gostev » Thu Aug 18, 2016 9:58 pm

9.5 will have SQL Server database restore performance improved in a few times.
Veeam Software
Posts: 21390
Liked: 2349 times
Joined: Sun Jan 01, 2006 1:01 am
Location: Baar, Switzerland

Re: SQL restore speed

Veeam Logoby arosas » Wed Apr 12, 2017 2:44 pm

9.5 still has the same speed issue. Has this been addressed or is installing the console on the target SQL servers the only solution?
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas

Re: SQL restore speed

Veeam Logoby foggy » Wed Apr 12, 2017 2:50 pm

Hi Tony, yes database restore performance was improved in v9.5 up to 3 times. If you're still seeing performance issues, I suggest contacting support for a closer look at your setup (reasons could be environmental).
Veeam Software
Posts: 14742
Liked: 1080 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: SQL restore speed

Veeam Logoby arosas » Mon Apr 24, 2017 4:59 pm 1 person likes this post

We have all SQL backups going to a certain repository. Support suggested changing the mount server setting for this repository to always be our SQL staging server instead of the Veeam server. When we did this the restore speed was tremendously better.
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas


Return to VMware vSphere

Who is online

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