C# project backup of database on remote desktop

Amit Rai

9y2.9k

I am working on a project in which I need to take backup on remote PC connected through LAN.

Since the backup worked successfully, on server PC (installed with MS SQL Server database), but I got the following Error while taking backup on another PC (installed setup of project only)

“Cannot open backup device

‘C:\...........\filename.back’. Operating System error 3( The system cannot find the path specified).

BACKUP DATABASE is terminating abnormally.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta9y ago
Hey
Just be assure that the directory must exists before taking backup to the destination.

Debug your code and check the value of your sql variable.
0
Gokhul Varman9y ago
It is very simple process just follow the instructions given in the referred link:http://sql-articles.com/articles/general/backup-sql-database-to-remote-location/
0
Subodh Natoo9y ago
Hi Amit,

Read Following link

https://www.howtogeek.com/51788/how-to-backup-sql-databases-to-a-network-share/
0
Amit Rai9y ago
@ Rajkiran Swain

actually, I have used the following code and it works nicely on my PC but through error on another PC connected through LAN.

FolderBrowserDialog dlg = new FolderBrowserDialog();
if (dlg.ShowDialog() == DialogResult.OK)
{
// textBox1.Text = saveFileDialog1.FileName;
string strLocation = dlg.SelectedPath;
string strDB = "BIRD_SMS";
con = new SqlConnection(strConn);
con.Open();

string sql = "BACKUP DATABASE " + strDB + " TO DISK ='" + strLocation + "\\" + strDB + "-" + DateTime.Now.Ticks.ToString() + ".bak'";
cmd = new SqlCommand(sql, con);
cmd.ExecuteNonQuery();
con.Close();
con.Dispose();

label1.Text = "";
btnBackup.Visible = false;
panel1.Visible = false;
MessageBox.Show("Database backup completed successfully,\n Please remove previous backup before taking backup again at same location!");

}

0
Rajkiran Swain9y ago
1. using (SqlConnection defaultSqlConnection = new SqlConnection("Insert Connection String Here"))
2. {
3. string backupDb = "BACKUP DATABASE [DatabaseName] TO DISK = 'C:\\Users\\Account\\Desktop\\Database Name.bak'";
5. using (SqlCommand backupCommand = new SqlCommand(backupDb, defaultSqlConnection))
6. {
7. defaultSqlConnection.Open();
8. backupCommand.ExecuteNonQuery();
9. }
10. }
0