topic SMSQL - Script to restore latest backup in Data Protection https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18531#M8655 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Is this possible?</P><P></P><P>Regards</P><P></P><P>Kirk</P></BODY></HTML> Thu, 05 Jun 2025 06:56:44 GMT penningtonkr 2025-06-05T06:56:44Z SMSQL - Script to restore latest backup https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18531#M8655 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>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.</P><P></P><P>Is this possible?</P><P></P><P>Regards</P><P></P><P>Kirk</P></BODY></HTML> Thu, 05 Jun 2025 06:56:44 GMT https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18531#M8655 penningtonkr 2025-06-05T06:56:44Z Re: SMSQL - Script to restore latest backup https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18536#M8656 <HTML><HEAD></HEAD><BODY><P>The SMSQL IAG has a sample script (and syntax) for a powershell command called restore-backup.</P><P></P><P>You can download the IAG from the NOW site.</P></BODY></HTML> Wed, 13 Apr 2011 13:57:26 GMT https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18536#M8656 curtish 2011-04-13T13:57:26Z Re: SMSQL - Script to restore latest backup https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18543#M8657 <HTML><HEAD></HEAD><BODY><P>I have no idea how i missed that, thanks for the pointer. </P></BODY></HTML> Wed, 13 Apr 2011 14:14:50 GMT https://community.netapp.com/t5/Data-Protection/SMSQL-Script-to-restore-latest-backup/m-p/18543#M8657 penningtonkr 2011-04-13T14:14:50Z