PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Sample T-SQL backup script

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 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 SQL Server backups by using the SQL Server Agent. Scheduling SQL Server backups by using SQL Server Agent provides information.

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

  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\