给你一段
private void Button1_Click(object sender, System.EventArgs e)
{ if (Directory.Exists("c:\\mydbstock\\") == false)
Directory.CreateDirectory("c:\\mydbstock\\");
systemsetting aaa= new systemsetting();
string strdate = "linpcontract"+DateTime.Now.Year+DateTime.Now.Month+DateTime.Now.Day+".bak";
if (aaa.BackupDatabase(strdate) == true)
{
systemsetting sss = new systemsetting();
sss.InsertSysLog(Session["LoginName"].ToString(),"备份数据库");
ShowErrMsg("备份数据库成功!");
}
else if (aaa.BackupDatabase(strdate) == false)
{
ShowErrMsg("备份数据库失败!");  
}
}
public bool BackupDatabase(string dbname) 
{
SqlConnection myCn00 = new SqlConnection(strConn);
try
{
string sBackup = "BACKUP DATABASE linpcontract TO DISK = 'c:\\mydbstock\\"+dbname+"' WITH NOINIT"; 
SqlCommand cmd = new SqlCommand(sBackup, myCn00);
myCn00.Open();
cmd.ExecuteNonQuery();
return true;
}
catch
{
return false;
}
finally
{
myCn00.Close();
}
}