Unsolved
1 Message
0
1797
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= " ' +
' -a "NSR_DFA_SI_DD_USER= " ' +
' -a "NSR_DFA_SI_DEVICE_PATH= " ' +
' -a "NSR_DFA_SI_DD_LOCKBOX_PATH=C:\Program Files\DPSAPPS\common\lockbox" ' +
' -c ' +
' -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