SQL Server Error Log causes the server disk C to be full

For example, if you limit the Log Size of a database to 500 mb, when the database uses up MB of space, logs will be recorded every time the database is connected.

 

 

The log content is as follows:

2008-07-25 09:50:01. 23 spid104 error: 9002, severity: 17, status: 6
09:50:01. 23 spid104 database 'xx' logs are full. Back up the transaction logs of the database to release some log space ..
2008-07-25 09:50:01. 23 spid160 error: 9002, severity: 17, status: 6
09:50:01. 23 spid160 database 'xx' logs are full. Back up the transaction logs of the database to release some log space ..
.....

 

 

The Log Path is c: \ Program Files \ Microsoft SQL Server \ MSSQL \ log

 

The minimum number of MSSQL log files is 6 (that is, there are at least 6 logs)

 

 

Current solutions:

1. Regularly clean up logs by writing scripts.

2. Set "fault recovery" for all databases on the server to a "simple" model.