Feature Request: Queued Restores

[kevine323]

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.
_________________
Kevin Eckart
Database Administrator
USA Truck, Inc
Kevin.Eckart@usa-truck.com
http://kevine323.blogspot.com/

[andy.campbell.smith]

Hi Kevin,

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/Content/SQL_Virtual_Restore/help/2.3/svr_HyperUtil

Let me know if that helps at all.
_________________
Andy Campbell Smith

Red Gate Technical Support Engineer

[StephenC]

Hi Kevin,

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:
http://help.red-gate.com/help/sql%20backup%207%20EAP/eap_download.htm

There isn't any Virtual Restore integration for v7 but may be included in a future release.

[SQLGator]

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.