PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

The following SQL-CLR script is an example of a restore script:

USE [master]
GO
DECLARE @returnCode int
EXEC @returnCode = dbo.emc_run_restore ' -c win8sqlsp.sharepoint.com -f
-t "02/03/2015 04:04:36 AM" -S normal -a "NSR_DFA_SI_DD_HOST=10.31.192.10"
-a "NSR_DFA_SI_DD_USER=ost" -a "NSR_DFA_SI_DEVICE_PATH=/ddsub7" -d
"MSSQL:dbtest" "MSSQL:db100"'
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

You can use any Microsoft SQL Server standard interfaces, such as the SSMS Query window and OSQL command prompt tool, to run the SQL-CLR scripts.

Best practices to back up Microsoft SQL Server with Application Direct provides guidelines for better performance of Microsoft SQL Server restores by using the Microsoft application agent for Application Direct SQL-CLR scripts.