Cant backup sql database with c#

Question

I tried this code samples

SqlCommand cmd = new SqlCommand();
SqlConnection con2 = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\schoolmate.mdf;Integrated Security=True;User Instance=True");
string sql = "BACKUP Database '" +Application.StartupPath+@"\schoolmate.mdf'" +" TO DISK ='D:\\schoolmate-" + DateTime.Now.Ticks.ToString() + ".bak'";
con2.Open();
cmd = new SqlCommand(sql, con2);
cmd.ExecuteNonQuery();

it gives a Incorrect syntax error.

And also tried

string sql = "BACKUP Database 'schoolmate.mdf' TO DISK ='D:\\schoolmate-" + DateTime.Now.Ticks.ToString() + ".bak'";

and

string sql = "BACKUP Database 'schoolmate' TO DISK ='D:\\schoolmate-" + DateTime.Now.Ticks.ToString() + ".bak'";

Which gives database not found error on cmd.ExecuteNonQuery();

Add a breakpoint on `con2.Open();` and check the value of `sql`. Try to run it on SSMS. You will probably find what is wrong. — Giannis Paraskevopoulos, Mar 11 '15 at 08:53
Refer to this. http://www.c-sharpcorner.com/UploadFile/rohatash/creating-sql-server-backup-file-with-C-Sharp/ — Earth, Mar 11 '15 at 08:53
What is your `sql` looks like in debugger before you execute it? — Soner Gönül, Mar 11 '15 at 08:55
"BACKUP Database 'D:\\works\\windows\\Schoolmate V2.0\\bin\\Debug\\schoolmate.mdf' TO DISK ='D:\\schoolmate-635616793105894858.bak'" this is the sql with file path — Mufeed Sha, Mar 11 '15 at 08:57
Yes file is there. And error is Incorrect syntax near 'D:\works\windows\Schoolmate V2.0\bin\Debug\schoolmate.mdf'. — Mufeed Sha, Mar 11 '15 at 08:59
Is that suppose to be schoolmate or schoolmate.mdf, which is the mdf file's name. Is database name different from it? — Mufeed Sha, Mar 11 '15 at 09:02
I guess the database name would be schoolmate, though it may differ from the file name. You should check and see how the db is called in SQL Server. You also not need the folder, so it should be something like `BACKUP Database schoolmate ...`. Note that you do not need the quotes around the db name. Check out https://msdn.microsoft.com/en-us/library/ms186865.aspx for more details. — Giannis Paraskevopoulos, Mar 11 '15 at 09:20

score 0 · Answer 1 · answered Mar 11 '15 at 11:08

0

Try this:

string sql = "BACKUP Database [schoolmate] TO DISK ='D:\\schoolmate-" + DateTime.Now.Ticks.ToString() + ".bak'";

answered Mar 11 '15 at 11:08

Multi1209

91
1
2

Cant backup sql database with c#

1 Answers1