Back up and restore databases in ASP. NET and asp.net

Back up and restore databases in ASP. NET and asp.net
I read the inventory management system in "C # project real-time recording" yesterday. Like the case in other books, it is nothing more than adding, deleting, querying, and modifying databases, however, this invoicing system has a function to back up and restore the database, which is quite interesting. After reading the code, it turns out that the database is backed up and restored through SQL statements, the SQL statement is as follows:
SQL code

1. -- Backup database
2. Backup database db_CSManage to disk = 'C: \ backup. Bak'
3. -- To restore a database, you must first back up the log file of the database to the original backup file.
4. Backup log db_CSManage to disk = 'C: \ backup. Bak'
5. Restore database db_CSManage from disk = 'C: \ backup. Bak'

Db_CSManage indicates the database name, and the path after disk is the path of the backup file storage.
Knowing the SQL statements makes it easier to use. NET code. The backup. NET code is as follows:
C # code

1. Try
2. {
3. If (txtPath. Text! = "" & TxtName122.Text! = "")
4. {
5. GetSqlConnection geCon = new getSqlConnection ();
6. SqlConnection con = geCon. GetCon ();
8. String strBacl = "backup database db_CSManage to disk = '" + txtPath. Text. Trim () + "\" + txtName. Text. Trim () + ". bak '";
9. SqlCommand Cmd = new SqlCommand (strBacl, con );
10. If (Cmd. ExecuteNonQuery ()! = 0)
11. {
12. MessageBox. Show ("Data Backup successful! "," Prompt box ", MessageBoxButtons. OK, MessageBoxIcon. Information );
13. This. Close ();
14. }
15. Else
16. {
17. MessageBox. Show ("data backup failed! "," Prompt box ", MessageBoxButtons. OK, MessageBoxIcon. Information );
18. }
20. }
21. Else
22. {
23. MessageBox. Show ("enter the correct backup location and file name! "," Prompt box ", MessageBoxButtons. OK, MessageBoxIcon. Information );
25. } // End
26. }
27. Catch (Exception ee)
28. {
29. MessageBox. Show (ee. Message. ToString ());
30. }

The following is the database restoration code. In this example, we found that the process related to the database must be deleted first, and then the database logs must be backed up to the backup file before restoration, then restore the backup file. Otherwise, an error occurs. The Code is as follows:
C # code

1. If (textPaht. Text! = "")
2. {
3. GetSqlConnection geCon = new getSqlConnection ();
4. SqlConnection con = geCon. GetCon ();
5. If (con. State = ConnectionState. Open)
6. {
7. Con. Close ();
8. }
9. String DateStr = "Data Source = niunan \ sqlexpress; Database = master; User id = sa; PWD = 123456 ";
10. SqlConnection conn = new SqlConnection (DateStr );
11. Conn. Open ();
13. // ------------------- Kill all processes connected to the db_CSManage database --------------
14. String strSQL = "select spid from master .. sysprocesses where dbid = db_id ('db _ csmanage ')";
15. SqlDataAdapter Da = new SqlDataAdapter (strSQL, conn );
17. DataTable spidTable = new DataTable ();
18. Da. Fill (spidTable );
20. SqlCommand Cmd = new SqlCommand ();
21. Cmd. CommandType = CommandType. Text;
22. Cmd. Connection = conn;
24. For (int iRow = 0; iRow <= spidTable. Rows. Count-1; iRow ++)
25. {
26. Cmd. CommandText = "kill" + spidTable. Rows [iRow] [0]. ToString (); // force stop a user process
27. Cmd. ExecuteNonQuery ();
28. }
29. Conn. Close ();
30. Conn. Dispose ();
31. //--------------------------------------------------------------------
33. SqlConnection sqlcon = new SqlConnection (DateStr );
34. Sqlcon. Open ();
35. String SQL = "backup log db_CSManage to disk = '" + textPaht. text. trim () + "'Restore database db_CSManage from disk = '" + textPaht. text. trim () + "'";
36. SqlCommand sqlCmd = new SqlCommand (SQL, sqlcon );
37. SqlCmd. ExecuteNonQuery ();
38. SqlCmd. Dispose ();
39. Sqlcon. Close ();
40. Sqlcon. Dispose ();
41. MessageBox. Show ("Data restored successfully! "," Prompt ", MessageBoxButtons. OK, MessageBoxIcon. Information );
42. MessageBox. Show ("to avoid data loss, the entire system is disabled after the database is restored. ");
43. Application. Exit ();
44. }
45. Else
46. {
47. MessageBox. Show ("select backup file! "," Prompt ", MessageBoxButtons. OK, MessageBoxIcon. Warning );
48. }

The source code of the entire invoicing system is attached.

• 08. rar (5.8 MB)

Aspnet implements database backup and Restoration

Backup: 133

How to write the backup and restoration database code in ASPNET

Both backup and restoration are implemented by calling SQL statements through ADO. NET. But you browse... If it is an ASP. NET project, it seems inappropriate. Permission conflict.