PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Performing SQL Server push backups by using the Microsoft application agent for Application Direct T-SQL scripts

About this task

To back up either all databases or only the specific databases of a SQL Server instance from a source host to a DD device by using a different host, perform the following steps:

Steps

Start SSMS on a different host that you use to perform the backup.
Connect to the source SQL Server instance on the source host.
In the SSMS window on the different host, click New Query.
In the New Query window, run the T-SQL script to perform the backup.

Results

You can either generate the T-SQL script by using the Microsoft application agent GUI on the source host and copy it to the New Query window on the different host or write the T-SQL script in the New Query window. Perform backups with the Microsoft app agent for Application Direct SSMS plug-in and Perform backups with T-SQL scripts provide information.

T-SQL push backup script

USE [master]
GO
DECLARE @returnCode int
EXEC @returnCode = dbo.emc_run_backup ' -c CLUST-SQL-02.contoso.com -A
CLUST-SQL-02.contoso.com -l full -y +0d -a "NSR_DFA_SI_DD_HOST=nmmddtwo.sp2010.com" -
a "NSR_DFA_SI_DD_USER=ost" -a "NSR_DFA_SI_DEVICE_PATH=/ddbmav2b75" -a
"NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE" "MSSQL$Inst1:Clus-SQL-01-DB01"
"MSSQL$Inst1:CLUST-SQL-02-DB01" "MSSQL$Inst1:CLUST-SQL-02-DB02" "MSSQL
$Inst1:CLUST-SQL-02-DB03"'
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

where:

CLUST-SQL-02.contoso.com is the source host that has the source SQL Server instance that you want to back up.
Inst1 is the source SQL Server instance, to which you must connect from the different host to perform the backup.
Clus-SQL-01-DB01, CLUST-SQL-02-DB01, CLUST-SQL-02-DB02, and CLUST-SQL-02-DB03 are the databases that you have selected in the Inst1 instance to back up.