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 federated backups of SQL Always On availability group databases by using T-SQL scripts

To perform federated backups, use the same backup command and options that Perform backups with T-SQL scripts describes, but with the following modifications:

  • Specify the Windows cluster name for <client_name> in -c <client_name>.
  • Specify the backup object name for <save_set_name> in -N <save_set_name>.
  • Specify #<AlwaysOn_Availability_Group_name> in the backup object name.

The options in the following sample scripts indicate these modifications.

NOTE:

The Microsoft application agent does not support backing up multiple Always On availability groups in the same operation.

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.

Sample T-SQL script to back up an entire Always On availability group

USE [master]
GO
DECLARE @returnCode int
EXEC @returnCode = dbo.emc_run_backup '-c SQL2012clus3.brsvlab.local
-S 4 -l full -y +30d -a "NSR_DFA_SI_DD_HOST=ddve-01"
-a "NSR_DFA_SI_DD_USER=sqlboost" -a "NSR_DFA_SI_PATH=/sqlboost"
-a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\ProgramFiles\DPSAPPS\common\lockbox"
-a "NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE"
-N "MSSQL$SQ12INST4#sql2012-aag3:" "MSSQL$SQ12INST4#sql2012-aag3:"'
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

Sample T-SQL script to back up multiple databases (a subset of databases) of an Always On availability group

USE [master]
GO
DECLARE @returnCode int
EXEC @returnCode = dbo.emc_run_backup '-c SQL2012clus3.brsvlab.local -
S 4 -l full -y +30d -a "NSR_DFA_SI_DD_HOST=ddve-01"
-a "NSR_DFA_SI_DD_USER=sqlboost" -a "NSR_DFA_SI_PATH=/sqlboost"
-a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\ProgramFiles\DPSAPPS\common\lockbox"
-a "NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE"
-N "MSSQL$SQ12INST4#sql2012-aag3:DB" "MSSQL$SQ12INST4#sql2012-aag3:database1"
"MSSQL$SQ12INST4#sql2012-aag3:database3" "MSSQL$SQ12INST4#sql2012-aag3:database8"'
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

Sample T-SQL script to back up a specific database of an Always On availability group

USE [master]
GO
DECLARE @returnCode int
EXEC @returnCode = dbo.emc_run_backup '-c SQL2012clus3.brsvlab.local -
S 4 -l full -y +30d -a "NSR_DFA_SI_DD_HOST=ddve-01"
-a "NSR_DFA_SI_DD_USER=sqlboost" -a "NSR_DFA_SI_PATH=/sqlboost"
-a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\ProgramFiles\DPSAPPS\common\lockbox"
-a "NSR_SKIP_NON_BACKUPABLE_STATE_DB=TRUE"
-N "MSSQL$SQ12INST4#sql2012-aag3:database1" "MSSQL$SQ12INST4#sql2012-aag3:database1"'
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

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: <>()\