Transaction Log

External Article

Manual cleanup Change Data Capture for a SQL Server database

  • Article

Kun Lee had a database where the log file kept growing and used 99.99% of the available space. He noticed miscellaneous change data capture objects still in the database as well as open transactions. This was causing his transaction log to continue to grow, but he couldn't disable CDC, because SQL Server thought it was not enabled. Read the full article to see his solution.

2013-09-11

3,682 reads

SQL Server Transaction Log Management eBook Download

Free eBook: SQL Server Transaction Log Management

  • Article

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.

2020-10-28 (first published: )

104,952 reads

External Article

Managing Transaction Logs in SQL Server

  • Article

The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed or none of them are. It ensures that , via rollback, only valid data is written out to the database, and it allows transactions to be played back to recreate the system state right before a failure. Robert Sheldon explains the various basic tasks involved in managing the transaction log.

2009-11-23

4,186 reads

Blogs

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

SQL Server Linux Container Images Got Smaller: Image Size and Startup Time Across Cumulative Updates

By

This week I was at PASS Data Community Summit in Seattle, and I attended...

Using AI to Build Semantic Models, Ontologies, and Fabric Data Agents

By

(This is the third post in a three-part series on how AI is changing...

Read the latest Blogs

Forums

Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Server-level Roles

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance

Tracking Inserted, Updated, and Deleted Rows with SQL Server OUTPUT

By Imran2629

Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...

Visit the forum

Question of the Day

Server-level Roles

In SQL Server 2025, can I alter a fixed server role?

See possible answers