SqlConnection con = new SqlConnection("Data Source=192.168.1.101;Initial Catalog=sun;Persist Security Info=True;User ID=sa;Password=123");
string time = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string ab = time;
string filename = Server.MapPath("../");
string path = filename + @"backupAndRestore/" + ab + ".bak";
string backupstr = "backup database sun to disk='" + path + "'";
SqlCommand cmd = new SqlCommand(backupstr, con);
try
{
con.Open();
cmd.ExecuteNonQuery();
Response.Write("<script>alert('备份成功! ');</script>");
}
catch
{
Response.Write("<script>alert('备份失败! ');</script>");
}
finally
{
con.Close();
}
Response.Write("<script type='text/javascript'>window.location='frmDBBackup.aspx';</script>");