100% completion in 8 minutes, recovery takes 2 hours

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


Postby Brian K » Wed Jul 20, 2011 5:17 pm

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?


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.
Brian K
Posts: 11
Joined: Wed Jul 20, 2011 1:49 pm

Postby james1248 » Thu Jul 21, 2011 11:10 am


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.

Posts: 2
Joined: Wed Jul 20, 2011 2:54 pm


Postby Brian K » Fri Jul 22, 2011 12:16 pm

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.
Brian K
Posts: 11
Joined: Wed Jul 20, 2011 1:49 pm


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 0 guests