I need to take SQL database backup on a remote machine through C#. I am using Backup Class provided by Microsoft.SqlServer.Management.Smo namespace.
When I call SqlBackup function of Backup Class I get the following error:
Cannot open backup device '\\WKS-123\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\CalDBServer.bak'. Operating system error 53(The network path was not found.).
BACKUP DATABASE is terminating abnormally.
I have already shared folder \\WKS-123\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ with "Full Control" permissions.
Please let me know if anybody has any idea regarding the error.
Regards,
Ajay
View Complete Post