Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

PDF

Performing Microsoft 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 Microsoft SQL Server instance from a source host to a DD device by using a different host, perform the following steps:

Steps

  1. Start SSMS on a different host that you use to perform the backup.
  2. Connect to the source Microsoft SQL Server instance on the source host.
  3. In the SSMS window on the different host, click New Query.
  4. 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

NOTE:

For self-service backups, the retention time displayed in the SSMS plug-in does not match the retention time displayed in PowerProtect Data Manager. The retention time in PowerProtect Data Manager is normalized and rounded off to midnight.

A retention setting in PowerProtect Data Manager overrides a retention setting specified by the -y option. 

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 Microsoft SQL Server instance that you want to back up.
  • Inst1 is the source Microsoft 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.

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  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: <>()\