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
eshteinman
Novice
 
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.
JoshuaPostSAMC
Expert
 
Posts: 118
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....
yunales
Influencer
 
Posts: 15
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.
Gostev
Veeam Software
 
Posts: 21621
Liked: 2411 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?
arosas
Influencer
 
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).
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 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.
arosas
Influencer
 
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas

Re: SQL restore speed

Veeam Logoby acoman » Tue Oct 17, 2017 1:41 pm

Hello,

I have the same problem with a SQL DB restore using the command shell of Veeam Explorer for Microsoft SQL Server, and thanks to veeam-backup-replication-f2/automate-restoring-latest-sql-database-backup-t26365.html#p237865 who provided with a nice script that can be used either with Windows task scheduler, or just configured to run at the end of the backup job.
My problem is that to restore a 10GB DB from a Nimble Storage repository takes around 3 hours.....

Did someone find any solution to improve the restore speed?

I forgot to mention I use the lates version of Veeam B&R 9.5.0.1038, on which as per Gostev vmware-vsphere-f24/sql-restore-speed-t33723.html#p185375 the speed transfer has been improved.

Regards
acoman
Lurker
 
Posts: 2
Liked: never
Joined: Fri Sep 05, 2014 6:27 pm
Full Name: Adrian Coman

Re: SQL restore speed

Veeam Logoby foggy » Wed Oct 18, 2017 11:39 am

Hi Adrian, I suggest you contacting support to verify whether your setup is optimal in terms of restore and identify the performance bottleneck. Btw, do you restore from a storage snapshot?
foggy
Veeam Software
 
Posts: 15295
Liked: 1133 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Previous

Return to VMware vSphere



Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest