eichmat
1 Copper

DDBoost: Redirected Restore not working

Trying to perform a redirected restore from a production backup to a test server of a relatively small DB (60GB).  Both servers are the same version and edition of SQL (2012).

Version 3.5 of the client is installed on the destination server--all work done on the destination server.

Connected to test server using the Microsoft Application Agent to generate the T-SQL script using a backup set from the other server (script below [names changed to protect the innocent]).  I always review the scripts generated to confirm all options (-C has the correct paths, -d has the correct destination and source database names, -c has the correct source server name, etc.).

When I execute: it never completes... it never initiates a "RESTORE DATABASE" command on the server.  I see no errors (or entries at all) in the DDBoost log files on the host.  When I cancel the restore attempt I get: "Thread was being aborted. Query was cancelled by user."  I let it run and run... I killed one attempt after 6-days and 21½ hours... nothing...

It isn't the DataDomain, as other redirected restores worked from different source and destination servers during the same time frame.  

Any suggestions?

 

(Anonymized) Script

USE [master]
GO
DECLARE @returnCode int
DECLARE @cmd nvarchar(max)

SELECT @cmd = ' -a "NSR_DFA_SI_DD_HOST=<datadomain server>" ' +
' -a "NSR_DFA_SI_DD_USER=<ddboost user>" ' +
' -a "NSR_DFA_SI_DEVICE_PATH=<backup path>" ' +
' -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" ' +
' -c <source server FQDN> ' +
' -a "SKIP_CLIENT_RESOLUTION=FALSE" ' +
' -C "''mydb_data''=''E:\DATA\mydb_0826.mdf'', ' +
    ' ''mydb_log'' =''F:\LOG\mydb_log_0826.ldf''" ' +
' -f -t "08/26/2018 12:00:37 AM" ' +
' -S normal ' +
' -d "MSSQL:mydb_prod0826" "MSSQL:mydb"'

EXEC @returnCode = dbo.emc_run_restore @cmd
IF @returnCode <> 0
BEGIN
RAISERROR ('Fail!', 16, 1)
END

Labels (3)
0 Kudos