Transaction Log

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-04-01 (first published: )

104,952 reads

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

Transforming JSON data with the help of Azure Data Factory - Part 4 - Passing Arrays around

By

(2020-May-24) It has never been my plan to write a series of articles about how...

3D Printing Ear Savers

By

On April 5th, I started printing ear savers for healthcare workers. I started with...

Updated Default Settings for Azure SQL Managed Instance Databases

By

A common saying about Azure is that it is always changing. This is a...

Read the latest Blogs

Forums

Are there application developers in here? Where are you doing your SQL?

By bbsimonbb

Hi, Are there app developers in this forum? Where does your app's SQL live?...

Building Better Software for Everyone

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Building Better Software for Everyone

Rounding and Sums

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Rounding and Sums

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers