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.