Summary of how SQL Server compresses log files

 

1. Method 1:
   Step 1:
   BackupLogDatabase_name with no _Log
   Step 2:
   Compress all data and log files of a specific database and execute DBCC shrinkdatabase (database_name)
2. Method 2:
   Another method is risky becauseSQLServer log files are not written to the master database file in real time. improper processing may cause data loss.
   1: DeleteLog
   Detach Database Enterprise Manager-> server-> database-> right-click-> detach Database
   2: DeleteLogFile
   Attach Database Enterprise Manager-> server-> database-> right-click-> attach Database
   This method prompts "re-createLog"Generate a newLog, The size is only 500 kb.
   Note: The first method is recommended.
   If you do not want it to become larger later.
   SQL2000 use:
   Right-click the database and choose Properties> Options> fault recovery> model> select simple model.
   Or useSQLStatement:
   Alter database name set recovery simple
3. Method 3:
   If the database uses the simple recovery mode, after the checkpoint is executed directly, and the database is shrunk again, all log records before the new minlsn are deleted.