Restore Database On Different Domain - Performance

Hi,

I'm trying to restore database on the server in the different domain.

The destination server is located in the physically remoted place.

First I tried UNC path (including IP address) with DBCC TRACEON | OFF (1807) optioin but it didn't work.

Some Internet document suggested that the FTP file transfer & restore locally on the remote domain but I didn't use this method because there is additional step.

Instead I used the following scripts:

DECLARE @COMMANDLINE VARCHAR(500)

SET @COMMANDLINE = 'NET USE B: \192.168.1.xxxsql_backup$ password /USER:SourceServer
ead_sql_backup /YES'
EXEC master..xp_cmdshell @COMMANDLINE

RESTORE DATABASE [DestinationDB]

FROM DISK = N'B:SourceBackup.bak' WITH
FILE = 1, NOUNLOAD , STATS = 10, REPLACE ,
MOVE N'dMSLog' TO N'D:MSSQLDataDatabase.ldf',
MOVE N'dMSData' TO N'D:MSSQLDataDatabase.mdf'

SET @COMMANDLINE = 'NET USE B: /DELETE /YES'
EXEC master..xp_cmdshell @COMMANDLINE

The script is working but it's extremly slow.

The size of database is only 1152.88 MB but it took more than 2 hours.

Is there any way that I can improve the performance?

Any advice would be appreciated

Thanks,

- Hyung -