SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups
Moderators: eddie davis, Colin Millerchip, fionag
It took 2.5 hours for virtual restore of 60GB databse on 64-bit SQL Server 2005 which I found bit strange (tested few times - same results). It was slower than running normal restore. How long it normaly takes for virtual restore of 60GB database and 250GB database?
Are the results I'm getting for virtual restore normal or not?
- Posts: 24
- Joined: Wed Mar 19, 2008 9:43 am
Virtual Restore times are normally in line with RESTORE VERIFYONLY times as a rule of thumb, which are typically much faster than full physical RESTORE DATABASE operations. We are releasing an update next week which includes some virtual restore performance enhancements, especially for SQB backup files. You should also try virtually restoring backups from other SQL HyperBac backup formats (such as HBC or ZIP) as well.
- Posts: 50
- Joined: Tue May 25, 2010 12:10 am
Return to SQL Virtual Restore 2
Who is online
Users browsing this forum: No registered users and 1 guest