Question

C#中备份数据库

private void BackupDatabase()
{
DateTime dt = DateTime.Now;
string dayName = dt.Day.ToString() + "日";
string dayPath = databaseSavePath + "\\" + dayName;
if(!Directory.Exists(dayPath))
{
Directory.CreateDirectory(dayPath);
}
string dirName = string.Format(@"{0}\{1}.bak", dayPath, dayName);//保存的文件名
BACKUP DATABASE HJ_ABDoor to disk = @dirName;
// string strSQL = string.Format(@"BACKUP DATABASE ABDoor to disk = '{0}'", dirName);
//SQLServer.SQLInquiry(strSQL);
}
不行，这个程序有什么问题？求高手指教

若以下回答无法解决问题，邀请你更新回答

Answer 1

///
///备份方法
///
SqlConnection conn = new SqlConnection("Server=.;Database=master;User ID=sa;Password=sa;");

SqlCommand cmdBK = new SqlCommand();
cmdBK.CommandType = CommandType.Text;
cmdBK.Connection = conn;
cmdBK.CommandText = @"backup database test to disk='C:\ba' with init";

try
{
conn.Open();
cmdBK.ExecuteNonQuery();
MessageBox.Show("Backup successed.");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.Close();
conn.Dispose();
}