For Mapping the following commands should be executed in the Destination Server
GO
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
---------------------------------------------
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
