topic SMSQL API in ONTAP Discussions https://community.netapp.com/t5/ONTAP-Discussions/SMSQL-API/m-p/60082#M14136 <HTML><HEAD></HEAD><BODY><P></P><P>I'm looking for a way to automate the restore of databases for my support and development users from SQL backups created with SMSQL.</P><P></P><P>Currently I have SMSQL creating a weekly full backup, and TLog backups every 4 hours every day. The volumes that are snapshotted are SnapMirrored to a SAN at my HQ location. From this second SAN, I would like a VB.Net app I wrote to gather the list of full backups, tlog backups, and databases contained in these backups. From this list, a user should be able to select a database to restore, which I would then request the local SMSQL to attach to our local test SQL server.</P><P></P><P>I have all the appropriate licenses for SMSQL, etc. I just want to know if there is a way to gather this data within a .Net app, and then command SMSQL to restore based on the criteria I've given it.</P></BODY></HTML> Thu, 05 Jun 2025 07:02:11 GMT drdabbles 2025-06-05T07:02:11Z SMSQL API https://community.netapp.com/t5/ONTAP-Discussions/SMSQL-API/m-p/60082#M14136 <HTML><HEAD></HEAD><BODY><P></P><P>I'm looking for a way to automate the restore of databases for my support and development users from SQL backups created with SMSQL.</P><P></P><P>Currently I have SMSQL creating a weekly full backup, and TLog backups every 4 hours every day. The volumes that are snapshotted are SnapMirrored to a SAN at my HQ location. From this second SAN, I would like a VB.Net app I wrote to gather the list of full backups, tlog backups, and databases contained in these backups. From this list, a user should be able to select a database to restore, which I would then request the local SMSQL to attach to our local test SQL server.</P><P></P><P>I have all the appropriate licenses for SMSQL, etc. I just want to know if there is a way to gather this data within a .Net app, and then command SMSQL to restore based on the criteria I've given it.</P></BODY></HTML> Thu, 05 Jun 2025 07:02:11 GMT https://community.netapp.com/t5/ONTAP-Discussions/SMSQL-API/m-p/60082#M14136 drdabbles 2025-06-05T07:02:11Z Re: SMSQL API https://community.netapp.com/t5/ONTAP-Discussions/SMSQL-API/m-p/60088#M14140 <HTML><HEAD></HEAD><BODY><P>Have you tried SMSQL PowerShell cmdlets? SMSP is using SMSQL Powershell cmdlets to do the similar things.</P><P></P><P> </P><P></P><P>Thanks,</P><P></P><P>-Qing</P></BODY></HTML> Fri, 14 Jan 2011 17:35:28 GMT https://community.netapp.com/t5/ONTAP-Discussions/SMSQL-API/m-p/60088#M14140 qzhang 2011-01-14T17:35:28Z