Current location - Health Preservation Learning Network - Healthy weight loss - How to solve the problem of too large log file in SQL SERVER 2000 database
How to solve the problem of too large log file in SQL SERVER 2000 database
Shrink database

Generally speaking, the shrinkage of SQL database can not greatly reduce the database size, but its main function is to shrink the log size, which should be carried out regularly to avoid the database log being too large.

1. Set the database mode to simple mode: Open SQL Enterprise Manager and click Microsoft in the root directory of the console.

Structured query language

Server-> Structured query language

Server group-> Double click to open your server-> Double-click to open the database directory-> Select the name of your database (such as forum database)-> then right-click and select Properties-> Select options-> Select Simple in failback mode, and then press OK to save.

2. Right-click the current database to view the shrinking databases in all tasks. In general, the default settings do not need to be adjusted, just click OK.

3. After shrinking the database, it is recommended to reset the database properties to the standard mode. The operation method is the same as the first point, because the log is often an important basis for restoring the database in some abnormal situations.