Discussions specific to the VMware vSphere hypervisor
Post Reply
mae2
Novice
Posts: 7
Liked: 1 time
Joined: Oct 16, 2014 7:02 am
Full Name: Matthias Suter
Contact:

Time required for a SQL Instance Restore

Post by mae2 » Mar 10, 2015 2:40 pm

Hello,
we have VEEAM B&R 8.0 Version 8.0.0.917 in use. The VEEAM Console is installed on a virtual server (VMWare vSphere 5).
Now i make a restore from a SQL DB which has a size from 23.2 GB. The Backupfile is stored on a fast HP EVA storage.
The time i need for the restore is 23 minutes.
Is this time normal or is it to long?
The DB Adminstrator says its to long for him, when he make a restore from a share, on which he has the backup of MS SQL directly written it needs only 6 minutes.
At this time I opened not support case.

Thank you for answers

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Time required for a SQL Instance Restore

Post by Vitaliy S. » Mar 10, 2015 4:32 pm

Hi Matthias,

Are you doing FLR restore of the db file? What is the performance rate if you try to upload any file (25 GB) to the datastore hosting your SQL Server VM from your backup repository?

Thanks!

Gostev
SVP, Product Management
Posts: 24804
Liked: 3566 times
Joined: Jan 01, 2006 1:01 am
Location: Baar, Switzerland
Contact:

Re: Time required for a SQL Instance Restore

Post by Gostev » Mar 10, 2015 9:28 pm

Hi, please open a support case and include it in this topic, as requested when you click New Topic - otherwise, this topic will be removed by moderators. We cannot investigate issues over forum posts and without having debug logs available, especially when it comes to performance issues. Thanks!

mae2
Novice
Posts: 7
Liked: 1 time
Joined: Oct 16, 2014 7:02 am
Full Name: Matthias Suter
Contact:

Re: Time required for a SQL Instance Restore

Post by mae2 » Mar 11, 2015 7:39 am

The Case Number is 00828332.

I do a Microsoft SQL Server Database Restore not a FL.
When i copy a file which has a size from 25 GB i need 7 minutes . The Speed is 42 MB/s.

Best regards

mae2
Novice
Posts: 7
Liked: 1 time
Joined: Oct 16, 2014 7:02 am
Full Name: Matthias Suter
Contact:

Re: Time required for a SQL Instance Restore

Post by mae2 » Mar 11, 2015 8:17 am

Hello again,
no i have make a File Level Restore from the DB files.
The Time in need for the FL restore is 11 minutes.

Best regards
mae2

Vitaliy S.
Product Manager
Posts: 23001
Liked: 1557 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: Time required for a SQL Instance Restore

Post by Vitaliy S. » Mar 11, 2015 11:44 am

Let our support team look through the log files and detect where the bottleneck is.

Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests