Asp. NET backup, restore SQL Server database

One, backup SQL Server database


string SQLSTR1 =   " server= (local);d atabase= ' "   +   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" ("This file already exists, please enter it again!") "); location= ' Default.aspx ' </script>") ; return ;
}
SqlCommand com= NewSqlCommand (SqlStr2, con);
Com. ExecuteNonQuery ();
Response.Write ("<script Language=javascript>alert (' Backup data Successful! ""); location= ' Default.aspx ' </script>");
}
Catch (Exception error)
... {
Response.Write (Error. message); Response.Write ("<script Language=javascript>alert (") Failed to backup data! ') </script>");
}
finally
... {
Con. Close ();
}Second, restore the SQL Server database


string Path =   This . FileUpload1.PostedFile.FileName;
// get backup path and database name
string dbname =   This . Dropdownlist1.selectedvalue;
string SQLSTR1 =   " server= (local);d atabase= ' "   +   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" ("Restore Data success!") "); location= ' Default.aspx ' </script>");
}
Catch (Exception error)
... {
Response.Write (Error. message); Response.Write ("<script Language=javascript>alert (") Failed to restore data! ') </script>");
}
finally
... {
Con. Close ();
}