SQLServer2000 Database Log File Security cleanup method!

The method is as follows: 1. first, make sure to back up the database (to reduce or clear the database of log files) 2. right-click the database, select and open the Properties window, find the option column, and change the fault recovery to simple.

The method is as follows: 1. first, make sure to back up the database (to reduce or clear the database of log files) 2. right-click the database, select and open the Properties window, find the option column, and change the fault recovery to simple.

The method is as follows:

1. First, make sure to back up the database (to reduce or clear the database of log files)

2. Right-click the database, select and open the "properties" window, find the "options" column, and change "complete" in the fault recovery to "simple ". For example:

After checking the log file size, it indicates that the log file content of the database has been safely cleared !!!~~

6. After the contraction operation is completed, you must refer to "Step 2" to change the "fault recovery" model to "complete "!

Other optional operations:

1. When creating a new database (or a created database), it is best to limit the log file size and growth mode in advance, such:

The settings here vary greatly depending on the database application. Generally, it is appropriate to set the "Maximum file size" of the log file to 1 GB (1024 MB. Of course, there is no fixed standard.

In addition, we recommend that you regularly check the size of log files and perform a database contraction operation as needed! This is really a good habit and Operation Method !~

This article is from the "Sleep worm nagging" blog. Please keep this source