Automate restore

Andrew Hodge

Is there anyway to automate a virtual restore ie perform the virtual restore via a SQL script.

Had a quick look through the help and this forum and cant see anything obvious....

chriskelly

It should be possible to add the SQL Virtual Restore script to a new job in the SQL Server Agent. It is relatively straight forward to do this through SSMS. You can then configure this job to run to whatever schedule you feel is appropriate.

(How to create a sql server agent job)
http://msdn.microsoft.com/en-us/library/ms190268.aspx

Andrew Hodge

Thanks, totally missed the view script button on the summary page (step 4) of the virtual restore wizard.

Andrew Hodge

Must of been having a slow 5 minutes because it is also documented on the bottom of this page....

http://www.red-gate.com/supportcenter/C ... 132667.htm

Andrew Hodge

The problem with this is you cant restore filenames based on wildcard like you can in sqlbackup.

So if you have a backup name that changes due to including the date and time then it becomes difficult to script for.

Can I have a feature request of allowing the virtual restore to allow wildcard filenames

Colin Millerchip

Andrew Hodge wrote:

The problem with this is you cant restore filenames based on wildcard like you can in sqlbackup.

So if you have a backup name that changes due to including the date and time then it becomes difficult to script for.

Can I have a feature request of allowing the virtual restore to allow wildcard filenames

Sorry for the loooong delay in replying, this slipped through due to holiday breaks.

This request is also covered in this thread http://www.red-gate.com/MessageBoard/viewtopic.php?p=49845

The short version is that SQL Virtual Restore uses native T-SQL syntax, and as such the approach proposed by epetro in the other thread (dynamic T-SQL) is the way to do this. That said, we're working on making scheduling easier to do, but I can't provide details on this yet.

SQLDBAsa

Hi Guys - any update on this?

I would really like to automate my daily restores with Virtual restore - as I am using date time filenames it's difficult to get them inside a tsql script to run thought a job.

If someone has an working solutions I would greatly appreciate it.

Regards,
R

Colin Millerchip

FYI, there's a blog post at http://www.sqlphilosopher.com/wp/2012/02/perform-dbcc-checkdb-weekly-using-red-gate-sql-virtual-restore/ where the author describes a script that handles the complexity of the dynamic t-sql. If you reach out to him, perhaps he'll share it?

Best regards,


Colin.

sqlphilosopher

Here is the Script that I wrote to handle the complexity of restoring each database on a given instance, using hyperbac virtual restore, and then performming DBCC Check DB Against it:

http://www.sqlphilosopher.com/wp/2013/0 ... db-script/

I apologize that it took me so long to get it pulled together.