Document on. NETBack up the SQL Server database with the following core technical code:
Using System. Data. SqlClient; Using System. IO; String SqlStr1 = "Server = (local); DataBase = master; Uid = sa; Pwd = "; String SqlStr2 = "Exec sp_helpdb "; 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 '";
|
1. The front-end code is as follows:
<Table> <Tr> <Td style = "width: 100px"> <span style = "font-size: 9pt"> operational data warehouse </span> </td> <Td> <asp: DropDownList ID = "DropDownList1" runat = "server" Font-Size = "9pt" Width = "124px"> </asp: DropDownList> </td> <Td style = "width: 100px"> </td> </Tr> <Tr> <Td style = "width: 100px"> <span style = "font-size: 9pt"> Backup name and location </span> </td> <Td style = "width: 100px"> <asp: textBox ID = "TextBox1" runat = "server" Font-Size = "9pt" Width = "117px"> </asp: TextBox> </td> <Td style = "width: 100px"> <span style = "font-size: 9pt; color: # ff3300"> (for example, D: \ beifen) </span> </td> </Tr> <Tr> <Td colspan = "3"> <asp: button ID = "Button1" runat = "server" Font-Size = "9pt" OnClick = "button#click" Text = "backup database"/> </td> </Tr> </Table>
|
2. The background code is as follows:
Using System. Data. SqlClient; Using System. IO; Public partial class _ Default: System. Web. UI. Page { Protected void Page_Load (object sender, EventArgs e) { If (! IsPostBack) { String SqlStr1 = "Server = (local); DataBase = master; Uid = sa; Pwd = "; String SqlStr2 = "Exec sp_helpdb "; SqlConnection con = new SqlConnection (SqlStr1 ); Con. Open (); SqlCommand com = new SqlCommand (SqlStr2, con ); SqlDataReader dr = com. ExecuteReader (); This. DropDownList1.DataSource = dr; This. DropDownList1.DataTextField = "name "; This. DropDownList1.DataBind (); Dr. Close (); Con. Close (); } } Protected void button#click (object sender, EventArgs e) { 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 ('this file already exists. Please input it again! '); Location = 'default. aspx' </script> "); Return; } SqlCommand com = new SqlCommand (SqlStr2, con ); Com. ExecuteNonQuery (); Response. Write ("<script language = javascript> alert ('data backed up successful! '); Location = 'default. aspx' </script> "); } Catch (Exception error) { Response. Write (error. Message ); Response. Write ("<script language = javascript> alert ('data backup failed! ') </Script> "); } Finally { Con. Close (); } } } Restore SqlServer Core technologies: String SqlStr1 = "Server = (local); database = '" + this. DropDownList1.SelectedValue + "'; Uid = sa; Pwd = "; String SqlStr2 = "use master restore database" + dbname + "from disk = '" + path + "'"; 1. Front-end <Table> <Tr> <Td style = "width: 100px; height: 21px"> <span style = "font-size: 9pt"> operational data warehouse </span> </td> <Td> <asp: DropDownList ID = "DropDownList1" runat = "server" Font-Size = "9pt" Width = "124px"> </asp: DropDownList> </td> <Td style = "width: 100px; height: 21px"> </td> </Tr> <Tr> <Td style = "width: 100px"> <span style = "font-size: 9pt"> operational data warehouse </span> </td> <Td style = "width: 100px"> <asp: fileUpload ID = "FileUpload1" runat = "server" Font-Size = "9pt" Width = "pixel PX"/> </td> <Td style = "width: 100px"> </Td> </Tr> <Tr> <Td colspan = "3"> <asp: button ID = "Button1" runat = "server" Font-Size = "9pt" OnClick = "button#click" Text = "Restore database"/> </td> </Tr> </Table> 2. Background Using System. Data. SqlClient; Using System. IO; Public partial class _ Default: System. Web. UI. Page { Protected void Page_Load (object sender, EventArgs e) { If (! IsPostBack) { String SqlStr1 = "Server = (local); DataBase = master; Uid = sa; Pwd = "; String SqlStr2 = "Exec sp_helpdb "; SqlConnection con = new SqlConnection (SqlStr1 ); Con. Open (); SqlCommand com = new SqlCommand (SqlStr2, con ); SqlDataReader dr = com. ExecuteReader (); This. DropDownList1.DataSource = dr; This. DropDownList1.DataTextField = "name "; This. DropDownList1.DataBind (); Dr. Close (); Con. Close (); } } Protected void button#click (object sender, EventArgs e) { String path = this. FileUpload1.PostedFile. FileName; // obtain the backup path and database name. 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 ('data restored successfully! '); Location = 'default. aspx' </script> "); } Catch (Exception error) { Response. Write (error. Message ); Response. Write ("<script language = javascript> alert ('data restoration failed! ') </Script> "); } Finally { Con. Close (); } } }
|