ASP.NET备份、还原SQL Server数据库

一、备份SQL Server数据库

string  SqlStr1  =   " Server=(local);database=' "   +   this .DropDownList1.SelectedValue  +   " ';Uid=sa;Pwd= " ;
string  SqlStr2  =   " backup database  "   +   this .DropDownList1.SelectedValue  +   "  to disk=' "   +   this .TextBox1.Text.Trim()  +   " .bak' " ;
SqlConnection con  =   new  SqlConnection(SqlStr1);
con.Open();
try ... {
    if (File.Exists(this.TextBox1.Text.Trim()))
    ...{
        Response.Write("<script language=javascript>alert('此文件已存在，请从新输入！');location='Default.aspx'</script>");return;
    }
    SqlCommand com = new SqlCommand(SqlStr2, con);
    com.ExecuteNonQuery();
    Response.Write("<script language=javascript>alert('备份数据成功！');location='Default.aspx'</script>");
}
catch  (Exception error)
... {
    Response.Write(error.Message);Response.Write("<script language=javascript>alert('备份数据失败！')</script>");
}
finally
... {
    con.Close();
}

二、还原SQL Server数据库

string  path  =   this .FileUpload1.PostedFile.FileName; 
// 获得备份路径及数据库名称
string  dbname  =   this .DropDownList1.SelectedValue;
string  SqlStr1  =   " Server=(local);database=' "   +   this .DropDownList1.SelectedValue  +   " ';Uid=sa;Pwd= " ;
string  SqlStr2  =   " use master restore database  "   +  dbname  +   "  from disk=' "   +  path  +   " ' " ;
SqlConnection con  =   new  SqlConnection(SqlStr1);
con.Open();
try ... {
    SqlCommand com = new SqlCommand(SqlStr2, con);
    com.ExecuteNonQuery();
    Response.Write("<script language=javascript>alert('还原数据成功！');location='Default.aspx'</script>");
}
catch  (Exception error)
... {
    Response.Write(error.Message);Response.Write("<script language=javascript>alert('还原数据失败！')</script>");
}
finally
... {
    con.Close();
}