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 restores by using the Microsoft application agent for Application Direct T-SQL scripts

About this task

To restore either all databases or only the specific databases of a Microsoft SQL Server instance from a DD device to a destination host by using a different host, perform the following steps.

NOTE:When the data to be restored exists in a Cloud Tier, perform a recall operation prior to the push restore operation.

Steps

  1. Start SSMS on a different host that you use to perform the restore.
  2. Connect to the destination Microsoft SQL Server instance on the destination 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 restore.

Results

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

T-SQL push restore script

Consider the following example T-SQL push restore script: 

USE [master]
GO
DECLARE @returnCode int
EXEC @returnCode = dbo.emc_run_restore ' -c clust-sql-01.contoso.com
-A clust-sql-02.contoso.com -f -t "06/22/2015 02:38:48 PM" -S normal
-a "NSR_DFA_SI_DD_HOST=nmmddtwo.sp2010.com" -a "NSR_DFA_SI_DD_USER=ost"
-a "NSR_DFA_SI_DEVICE_PATH=/ddbmav2b75" -d "MSSQL$Inst1:CLUST-SQL-02-
DB02" "MSSQL$Inst1:CLUST-SQL-02-DB01"'
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

where:

  • clust-sql-01.contoso.com is the source host from which the backup was performed.
  • Inst1 is the destination Microsoft SQL Server instance, to which you must connect from the different host to perform the restore.
  • CLUST-SQL-02-DB02 is the destination database.
  • CLUST-SQL-02-DB01 is the database that was backed up from the source host.

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