PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

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

USE [master]
GO
DECLARE @returnCode int
8 -l full -N "Set1" -y +0d -a "NSR_DFA_SI_DD_HOST=10.31.192.10" -a
"NSR_DFA_SI_DD_USER=ost" -a "NSR_DFA_SI_DEVICE_PATH=/ddsub7" -a
"NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE" "MSSQL:"'
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 line tool, to run the SQL-CLR scripts.

You can use the SQL-CLR script to schedule Microsoft SQL Server backups by using the SQL Server Agent. Scheduling Microsoft SQL Server backups by using SQL Server Agent provides information.

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