Data Backup and Recovery

SMSQL - Script to restore latest backup

penningtonkr
2,758 Views

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

1 ACCEPTED SOLUTION

curtish
2,758 Views

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

2 REPLIES 2

curtish
2,759 Views

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
2,758 Views

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

Public