SMSQL - Script to restore latest backup

[penningtonkr]

Hi,

Is there a way to script a restore job on a database through SMSQL, I can see lots of commands and documentation regards this for SnapDrive but not anything for SMSQL.

What I want to be able to do is to provide the script to the DBA team which will restore the databases to the latest backup taken within SMSQL.

Is this possible?

Regards

Kirk

[curtish · Accepted solution]

The SMSQL IAG has a sample script (and syntax) for a powershell command called restore-backup.

You can download the IAG from the NOW site.

[penningtonkr]

I have no idea how i missed that, thanks for the pointer.