CODEWITHSUNDEEP
sql-server
John L.
John L.

Reputation: 1953

Why Does SQL Server Log File Size Decrease

I am using the SQL script on Select SQL Server database size in order to monitor how much my database file usage increased. I am particularly inspecting the "data_used_size" and "log_used_size" fields. But I notice that while the data file usage consistently increases after a set of activities, log file usage sometimes increases and sometimes decreases, thus always staying at a certain level. Why is this?

Upvotes: 1

Views: 98

Answers (1)

Martheen
Martheen

Reputation: 5580

This is documented in MSDN article about Transaction Log

  1. If the DB is using simple recovery model, after a checkpoint
  2. If full recovery model or bulk-logged recovery model is used, then after a log backup.

Upvotes: 4

Related Questions