Reputation: 163
I am trying to create a c# function that will backup and restore an mssql server 2005 db. I have tried almost everything on the net but I have no luck. On my local machine everything works perfect, but when I tried remotely I take the error:Operating system error 3... BACKUP DATABASE is terminating abnormally. Iam using Server.MapPath("~/mypath") for the path. I have also tried the following, with no luck: Tranferring backup files from a remote sql server
Upvotes: 3
Views: 1012
Reputation: 216353
Operating system error code 3(The system cannot find the path specified.).
You should use a local directory on the remote server to save the backup
(of course the user connected should have permission to reach that local directory)
Upvotes: 3