首先我們先分析asp備份sql數據庫的代碼，詳細如下：

備份sqlserver數據庫:
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();
}

下面是asp.net還原sql數據庫的方法，代碼如下：

還原sqlserver數據庫:
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();
}