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