PowerProtect Data Manager 19.9 Microsoft Application Agent 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 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 SQL Server with Application Direct provides guidelines for better performance of SQL Server restores by using the Microsoft application agent for Application Direct SQL-CLR scripts.