hasti shirazy
چهارشنبه 30 مرداد 1387, 22:49 عصر
سلام دوستان من از کدهای زیر برای back up ,restor استفاده می کنم خطا می دهد وآیا راه بهتری هست به من معرفی کنید؟وback up ,restor چه فرقی با هم دارن؟
backup:
connection cs = new connection();
cs.open();
SaveFileDialog s = new
SaveFileDialog();
s.ShowDialog();
SqlCommand cm = new SqlCommand("backup database test_db to
disk=" + "'" + s.FileName + "'", cs.conection);
cm.ExecuteNonQuery();
cs.closeconnection();
this.Close();
restore:
OpenFileDialog o = new OpenFileDialog(); o.ShowDialog();
connection cs = new connection();
cs.open();
SqlCommand cm2 = new SqlCommand("use master " +
"alter database test_db " +
"set offline with rollback immediate " +
"restore database test_db from disk=" + "'" +
o.FileName" + "' with replace,restart " +
"alter database test_db set online with
rollback immediate", cs.conection);
cm2.ExecuteNonQuery();
cs.closeconnection();
this.Close();
backup:
connection cs = new connection();
cs.open();
SaveFileDialog s = new
SaveFileDialog();
s.ShowDialog();
SqlCommand cm = new SqlCommand("backup database test_db to
disk=" + "'" + s.FileName + "'", cs.conection);
cm.ExecuteNonQuery();
cs.closeconnection();
this.Close();
restore:
OpenFileDialog o = new OpenFileDialog(); o.ShowDialog();
connection cs = new connection();
cs.open();
SqlCommand cm2 = new SqlCommand("use master " +
"alter database test_db " +
"set offline with rollback immediate " +
"restore database test_db from disk=" + "'" +
o.FileName" + "' with replace,restart " +
"alter database test_db set online with
rollback immediate", cs.conection);
cm2.ExecuteNonQuery();
cs.closeconnection();
this.Close();