Red Gate forums :: View topic - Slow restore from compressed backups
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Virtual Restore 2
SQL Virtual Restore 2 forum

Slow restore from compressed backups

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
mikecare



Joined: 02 Aug 2012
Posts: 5
Location: NC, US

PostPosted: Thu Aug 02, 2012 6:53 pm    Post subject: Slow restore from compressed backups Reply with quote

Love the functionality, however my restores seem to take 4x as long. I am using native compressed Prod backups from 64bit Enterprise Edition. I then copy them over to my Dev region and restore. For native Dev Edition restores a 126 GB db/ 27 GB backup takes about 8 min to restore, when using Virtual restore, it took 57 min to restore. For a similar size db it took about 45 min up from a 10 min native restore.

Is this normal for native compressed backups?
Back to top
View user's profile Send private message
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Fri Aug 03, 2012 12:09 pm    Post subject: Reply with quote

Hi Mikecare,

This shouldn't be normal behaviour, are the SQL Server versions between the two machines the same or different?

Also when completed, have big are the vmdf/vmdf/vldf files in explorer?

Thanks,
_________________
Matthew Flatt
Test Engineer, HyperBac
Back to top
View user's profile Send private message
mikecare



Joined: 02 Aug 2012
Posts: 5
Location: NC, US

PostPosted: Fri Aug 03, 2012 1:06 pm    Post subject: Reply with quote

They are somewhat different

Prod version: Microsoft SQL Server 2008 (SP2) - 10.0.4000.0 (X64) Sep 16 2010 19:43:16 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 <X64> (Build 3790: Service Pack 2)

Dev version: Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (Intel X86) Sep 22 2011 00:28:06 Copyright (c) 1988-2008 Microsoft Corporation Developer Edition on Windows NT 6.0 <X86> (Build 6002: Service Pack 2)
Back to top
View user's profile Send private message
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Mon Aug 06, 2012 9:45 am    Post subject: Reply with quote

Hi Mikecare,

Did you notice the size of the vmdf/vndf/vldf file sizes at the end of the restore?

Thanks,
_________________
Matthew Flatt
Test Engineer, HyperBac
Back to top
View user's profile Send private message
mikecare



Joined: 02 Aug 2012
Posts: 5
Location: NC, US

PostPosted: Mon Aug 06, 2012 2:48 pm    Post subject: Virtual Sizes Reply with quote

Yes, they were about 53 MG and 80 MG. Seemed nice and small!
Back to top
View user's profile Send private message
mikecare



Joined: 02 Aug 2012
Posts: 5
Location: NC, US

PostPosted: Thu Aug 09, 2012 10:21 pm    Post subject: Support? Reply with quote

Do I need to run a restore again to get more info? Not sure if this is standard or if I can do something different to gain the standard restore script time.
Back to top
View user's profile Send private message
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Fri Aug 10, 2012 8:37 am    Post subject: Reply with quote

Hi mikecare,

Sorry for the delay, I have been trying to reproduce your issue here but unfortunately with no success. Are you using version 5.7 of the product?

Would you be able to run both the native and SVR restores again with some extra SQL Server logging turned on for comparison?

Execute the following against the master db:

DBCC TRACEON (3004, 3605, -1)

Run a native restore followed by an SVR restore.

Turn off the extra logging:

DBCC TRACEOFF (3004, 3605, -1)

I would like to know if there is a specific part of the restore process which is taking the extra time, such as the recovery phase.

Thanks,
_________________
Matthew Flatt
Test Engineer, HyperBac
Back to top
View user's profile Send private message
mikecare



Joined: 02 Aug 2012
Posts: 5
Location: NC, US

PostPosted: Fri Aug 10, 2012 3:21 pm    Post subject: Reply with quote

I am running 5.7. I was able to run as you requested. What is the best way to get you the file or data? The backup ran in about 14 min for the native restore vs 45 min for the virtual
Back to top
View user's profile Send private message
Matthew Flatt



Joined: 15 Jan 2008
Posts: 253

PostPosted: Fri Aug 10, 2012 3:29 pm    Post subject: Reply with quote

If you can email support@red-gate.com and reference this forum post that would be great.

Thanks,
_________________
Matthew Flatt
Test Engineer, HyperBac
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group