Data Backup and Recovery

SMSQL - Script to restore latest backup

penningtonkr
2,757 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,757 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,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.

penningtonkr
2,757 Views

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

Public