When i am taking the backup in network share drive with mention below TSQL.
Use DatabaseName
Go
Backup Database DatabaseName
To Disk=N'H:\DatabaseBackup\DatabaseName.bak';
Go
I am getting the following below error in SSMS.
Msg 3201, Level 16, State 1, Line 1
Cannot open backup device 'H:\DatabaseBackup\DatabaseName.bak'
. Operating system error 3(The system cannot find the path specified.).
Msg 3013, Level 16, State 1, Line 1
BACKUP DATABASE is terminating abnormally.
As I have checked to 'xp_cmdshell' through this TSQL . The run_value & config_value as follows:
name minimum maximum config_value run_value
xp_cmdshell 0 1 1 1
Note : Here H is my Network share.
Any suggestion will be appreciated.