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

SQLServerCentral Article

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

  • 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. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

3 (2)

2013-08-26

6,489 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

Blogs

Daily Coping 8 Dec 2022

By

Today’s coping tip is to be curious. Learn about a new topic or an...

#PowershellBasics: Warnings and how to hide them.

By

One of my favorite parts of having a new job is that I learn...

Daily Coping 7 Dec 2022

By

Today’s coping tip is to stop for a minute when you walk outside and...

Read the latest Blogs

Forums

Problem Importing NULLs in varchar field

By John524

hello, This is something I'm really struggling with and haven't found much when I...

SQL Server 2022 is RTM

By Grant Fritchey

You can get your hands on SQL Server 2022 right now and this forum,...

Blocking

By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers