| Author |
Message |
Brian K
Joined: 20 Jul 2011
Posts: 11
|
 Posted: Wed Jul 20, 2011 6:17 pm Post subject: Re: |
 |
|
| 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 |
|
 |
james1248
Joined: 20 Jul 2011
Posts: 2
|
| Posted: Thu Jul 21, 2011 12:10 pm Post subject: |
|
|
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 |
|
|
Brian K
Joined: 20 Jul 2011
Posts: 11
|
| Posted: Fri Jul 22, 2011 1:16 pm Post subject: Re: |
|
|
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 |
|
|
|
|
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
