Mapping the Backup path in destination SQL Server

For Mapping the following commands should be executed in the Destination Server

GO

-- Update currently configured values for advanced options.

RECONFIGURE

GO

-- To enable xp_cmdshell

EXEC sp_configure 'xp_cmdshell', 1

GO

-- Update currently configured values for advanced options.

RECONFIGURE

GO

---------------------------------------------

\\TRIG-O-1898\aa Servername\Foldername (The foldername should not contain space)

EXEC xp_cmdshell 'NET USE M: \\TRIG-O-1898\aa trig@123 /USER:trigchn\spdev23'

EXEC xp_cmdshell 'Dir M:'

--------------------------------------------------

For Restore in command:

RESTORE DATABASE WSS_Content_10000 FROM DISK = 'M:\WSS_Content_10000_backup_2016_11_11_200006_8301046.BAK'

GO

 --------------------------------------------------

For delete the network mapping

EXEC XP_CMDSHELL 'net use M: /delete'

------------------------------------------------

After this commands executed successfully, take Content Databases backup and specify the path from Source and restore in Destination