Equilibrium
Equilibrium

Reputation: 163

Remote MS Sql server backup and restore from C#

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

Answers (1)

Steve
Steve

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

Related Questions