CODEWITHSUNDEEP
sqlsql-server-2008-r2database-administration
ramires.cabral
ramires.cabral

Reputation: 940

Backup a Sql Server 2008 r2 transaction log clean file space:

Backup a Sql Server 2008 r2 transaction log cleans file space but not shrink it? Is that true?

Upvotes: 0

Views: 622

Answers (1)

Jon Boulineau
Jon Boulineau

Reputation: 451

Correct. Technically, backing up a transaction log in any version of SQL Server will mark as much space as possible as reusable, but will not shrink the file. This is by design. The file is designed to grow to a size required to log transactions between backups to avoid performance issues related to file growth events (among other things). If you have issues with disk space, you need to take log backups more often, set it to SIMPLE mode (if appropriate for your recovery strategy), or increase disk space.

Shrinking the file, in most cases, is not best practice.

Upvotes: 2

Related Questions