The MS SQL database is located in the C disk has become a big solution

C:\Program Files\Microsoft SQL Server\mssql.1\mssql\log

In general, the errorlog in this folder becomes very large. So to clean up.

Executing an EXEC sp_cycle_errorlog will create a new errorlog to overwrite the old errorlog. Just Loop 7 times to cover the errorlog all over again.

1. Open Query Analyzer, enter command
BACKUP LOG database_name with NO_LOG
2. Then open Enterprise Manager--right-click the database to compress--all tasks--shrink the database--Shrink file--Select log file-

The MS SQL database is located in the C disk has become a big solution