Slow Virtual Restore

SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups

Moderators: eddie davis, Colin Millerchip, fionag

Slow Virtual Restore

Postby mat.raftree » Thu Sep 30, 2010 6:46 pm

I have been testing Virtual Restore times and in my environment, performing a full restore from a SQLBackup 6 .sqb file take about 60 minutes. I have made several attempts to do a virtual restore on the same SQB file and they run for about 180+ minutes each time.

I did the install of the hyperbac components with a recent download and it appears to be version 5.0.33.0 on them and I am running Windows 2003 Server 64bit and SQL Server 2008 Enterprise edition.

The SQB file is about 100GB and was perfomed with SQLBackup using 2 threads. I restores successfully from SQLBackup up to a 500GB database.

Is there anything obvious I am missing? I basically ran the Virtual Restore wizard and then copied the script and ran that from a query window (it is restoring all the files to .vmdf/.vndf files).

Is this expected behavior? I would have assumed that VirtualRestore would make the DB available faster than running a full resotre with SQLBackup.

Thanks for any help or thoughts
mat.raftree
 
Posts: 3
Joined: Tue Dec 29, 2009 7:33 am

Postby eddie davis » Thu Oct 07, 2010 1:14 pm

Hi

I believe that my colleague, Jeff Aven, has already contacted you regarding this problem outside of this forum.

Do you require any further assistance?

Many Thanks
Eddie
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
eddie davis
 
Posts: 942
Joined: Wed Jun 14, 2006 3:47 pm
Location: Red Gate Software

virtual restore does not complete

Postby stevenwatson » Fri May 20, 2011 1:09 am

Could the details of this issue be posted, as I believe I'm having a similar issue.

On a large sql backup DB the virtual restores just continue indefinitely.

The restore is in two parts.
First the full backup is restored and left ready for the differential restore.
This seems to happen although a bit slower than a normal restore.
However the differential restore does not complete even if left running for several days.
stevenwatson
 
Posts: 3
Joined: Thu May 19, 2011 2:25 am
Location: Australia

Don't forget the stats

Postby epetro » Fri Jun 03, 2011 7:41 pm

I too am attempting a large restore for evaluating purposes. My scenario is across the network as I want to eventually schedule DBCC processes on all our production servers once a week from a central location.

I found adding the "STATS=10" to the restore script helped me track the progress. I think you can use lower (%) to track tighter.

The process seems disk heavy at the source, so I may just pull the .sqb file locally to faster disks first.
epetro
 
Posts: 55
Joined: Tue May 31, 2011 7:55 pm
Location: Zotec Partners

Postby rplescia » Tue Nov 01, 2011 4:22 pm

What is the average restore/mount time for a uncompressed 1GB SQL backup file using SVS? I'm restoring a 68GB uncompressed .sqb file which has been running for over 4 hours now and is roughly 75% complete. The data files are also at 21GB and still growing... Is this normal?

Server spec
HP DL 585 G3, 4 CPUs, 16GB RAM, SQL 2008 R2 64-bit

HyperBack 5.4.1.4
SQL Virtual Restore 5.2.1.7
rplescia
 
Posts: 3
Joined: Tue Nov 01, 2011 4:07 pm

Postby jhboricua » Wed Jan 23, 2013 7:41 pm

So what is the scoop on this?

I'm just having the same issue with slow restores on a 40GB SQL Backup 6 SQB file (1 stream, compression level=1). At the current rate of restore it will take >200 minutes to complete!!!

I'm running the latest version of the SQL virtual Restore (downloaded it 2 weeks ago from the Red-Gate website).

I've found other old threads here alluding to slow virtual restore issues with no indication that the slowness issue has ever been resolved.

Can someone from Red Gate update shed some light on this?
jhboricua
 
Posts: 28
Joined: Tue Mar 15, 2011 3:54 pm


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests