Restore DB from UNC Path

Restore DB from UNC Path

While restoring MS Sql DB from a UNC path we at times face an error saying

 - Can not find the path specified.

Cause :
This error is due to sql server not having access permission.

Issue can be resolved using following :


EXEC sp_configure 'show advanced options', 1
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 Z: \\Path Password /USER:domain\uName'