Data Backup and Recovery Discussions
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?
See The 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.
View solution in original post
I have no idea how i missed that, thanks for the pointer.