SQL Server log files, when you perform database data update, delete, add a log record, if your log is not cleaned, you will get a big better ~~~ ----------- - Treatment method: 1. Timed the following statement to empty the log recycling log space
Use your library name godump Transaction library name with no_log - truncated transaction logs
DBCC ShrinkFile (2,0) - Shrink Log Space GO
2. Set your database mode into simple mode:
Enterprise Manager - "Expand Database -" Select your database - "Right-click" Properties "-" Option - "Select the model" simple ", and hook" automatic contraction "
