Red Gate forums :: View topic - 100% completion in 8 minutes, recovery takes 2 hours
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

100% completion in 8 minutes, recovery takes 2 hours

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Go to page Previous  1, 2
Author Message
Brian K



Joined: 20 Jul 2011
Posts: 11

PostPosted: Wed Jul 20, 2011 6:17 pm    Post subject: Re: Reply with quote

Matthew Flatt wrote:
Hi Brian,

Those log files are definitely too old to worry about then.

It does sound like the backup may have been taken at an inconvenient time, would you be able to try another backup for that database and compare results?

Thanks,


We have seen this with two different backups, both scheduled at 1am on Saturday. I'll check out maintenance plans and other jobs and see what's going on then.
Back to top
View user's profile Send private message
james1248



Joined: 20 Jul 2011
Posts: 2

PostPosted: Thu Jul 21, 2011 12:10 pm    Post subject: Reply with quote

Hi,

I'm seeing the same thing. Virtual Restore takes much longer than normal restores. The log files are also very large, growing by a few lines every millisecond!! - so I think that is why it's slow for me. Haven't been able to fix it yet. But make sure your log files aren't as busy as mine.

Cheers.
James
Back to top
View user's profile Send private message
Brian K



Joined: 20 Jul 2011
Posts: 11

PostPosted: Fri Jul 22, 2011 1:16 pm    Post subject: Re: Reply with quote

We have done some more exhaustive testing.

About a third of our database backups we're restoring onto a reporting server have this same problem.

The backups typically take four to eight times longer than a normal SQB restore.

I really can't find a common cause for this issue, redo/recovery takes less than a minute with Redgate SQL Backup, and two hours + with Virtual Restore.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Go to page Previous  1, 2
Page 2 of 2

 
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