Feature Request: Queued Restores

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

Moderators: eddie davis, Colin Millerchip, fionag

Feature Request: Queued Restores

Postby kevine323 » Fri Feb 03, 2012 11:05 pm

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/
kevine323
 
Posts: 39
Joined: Thu Jul 27, 2006 10:23 pm

Postby andy.campbell.smith » Mon Feb 06, 2012 2:45 pm

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/C ... _HyperUtil

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

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby StephenC » Wed Feb 08, 2012 10:47 am

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.
StephenC
 
Posts: 306
Joined: Mon Oct 15, 2007 9:18 am
Location: Cambridge

Postby SQLGator » Fri Dec 07, 2012 8:57 pm

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.
SQLGator
 
Posts: 10
Joined: Fri Dec 02, 2011 3:52 pm


Return to SQL Virtual Restore 2

Who is online

Users browsing this forum: No registered users and 1 guest