SQL Virtual Restore: Rapidly mount live, fully functional databases direct from backups
I like to request the ability to queue up a set of database backup's to be restored, have DBCC CheckDB ran, and then drop the database. All of the CheckDB messages should be sent to a log file to be reviewed after the entire operation is complete.
- Posts: 39
- Joined: Thu Jul 27, 2006 9:23 pm
It sounds like you could do what you're after by scripting restores from the command line using HyperUtil - we've got a support article up here about it:
http://www.red-gate.com/SupportCenter/C ... _HyperUtil
Let me know if that helps at all.
Andy Campbell Smith
Red Gate Technical Support Engineer
- Posts: 173
- Joined: Thu Oct 20, 2011 10:19 am
- Location: Red Gate Software
with our upcoming release of SQL Backup Pro 7 you can schedule restores, run DBCC CHECKDB and drop the database following verification.
You can find the EAP builds here:
There isn't any Virtual Restore integration for v7 but may be included in a future release.
- Posts: 305
- Joined: Mon Oct 15, 2007 8:18 am
- Location: Cambridge
You can schedule them but you have to do these one at a time, how about a wildcard in the database name and let it do the restores one at a time.
- Posts: 10
- Joined: Fri Dec 02, 2011 2:52 pm
Return to SQL Virtual Restore 2
Who is online
Users browsing this forum: No registered users and 0 guests