PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

Performing 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 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

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