Red Gate forums :: View topic - Feature Request: Queued Restores
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Virtual Restore 2
SQL Virtual Restore 2 forum

Feature Request: Queued Restores

Search in SQL Virtual Restore 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
kevine323



Joined: 27 Jul 2006
Posts: 39

PostPosted: Fri Feb 03, 2012 11:05 pm    Post subject: Feature Request: Queued Restores Reply with quote

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/
Back to top
View user's profile Send private message Send e-mail AIM Address Yahoo Messenger
andy.campbell.smith



Joined: 20 Oct 2011
Posts: 173
Location: Red Gate Software

PostPosted: Mon Feb 06, 2012 2:45 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
StephenC



Joined: 15 Oct 2007
Posts: 315
Location: Cambridge

PostPosted: Wed Feb 08, 2012 10:47 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
SQLGator



Joined: 02 Dec 2011
Posts: 10

PostPosted: Fri Dec 07, 2012 8:57 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
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