备份数据库

private void b_backup_Click(object sender, System.EventArgs e)
  {
   

   
   SqlConnection conn = new SqlConnection(strConn);
   string nowpath=Request.PhysicalApplicationPath + "Exported//";

   string sql=null;
   if( conn.State == ConnectionState.Open)
    conn.Close(); 
   conn.ConnectionString = strConn;
   conn.Open();  
       
   sql="backup database WTC to disk='"+nowpath+"//"+filename+"' with format,name='Full Backup of TradeDb/SQL'";
   
   bool flag = false;
   try
   {
    SqlCommand  cmd = new SqlCommand(sql, conn);
    cmd.ExecuteNonQuery();
    flag = true;
    //MessageBox.Show("成功备份数据！备份记录为："+nowpath+"//数据备份文件(不要删除).dll"," 成功了！", MessageBoxButtons.OK, MessageBoxIcon.Information );
   }
   catch(Exception)
   {

    flag = false;
    //MessageBox.Show("出现错误，请与作者联系！"+err.ToString() ,"出错了!",MessageBoxButtons.OK ,MessageBoxIcon.Question  );
     
   }
   finally
   {
    conn.Close();
    
    
   }

   //备份记录为："+nowpath+"//数据备份文件(不要删除).dll
 
   if(flag == true) //保存成功！
   {
    //Response.Write("<script language='JavaScript'>alert('成功备份数据！备份记录为："+nowpath+"//数据备份文件(不要删除).dll');</script>");
                //下載到客戶耑
    WriteStream();

   }
   else //保存失败！
   {
    Response.Write("<script language='JavaScript'>alert('出现错误，请与作者联系！');</script>");
   }
     

   //
  }