Gail Shaw

  • Interests: Computer Graphics, Aikido, Roleplaying

Stairway to Transaction Log Management

Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model

A DBA may consider switching a database to the BULK_LOGGED recovery model in the short term during, for example, bulk load operations. When a database is operating in the BULK_LOGGED model these, and a few other operations such as index rebuilds, can be minimally logged and will therefore use much less space in the log

5 (2)

You rated this post out of 5. Change rating

2025-07-30 (first published: )

5,959 reads

Blog Post

Pluralsight Free April

It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...

2020-04-16 (first published: )

494 reads

Blog Post

Pluralsight Free April

It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...

2020-04-07

6 reads

Blogs

The Book of Redgate: Meetings

By

I think we might have forgotten this a bit, but on one of the...

New article: Automating SQL Server Builds

By

I refresh my test SQL Servers at least monthly with a fresh VM. Setting...

Leading with Accountability: How Extreme Ownership Transforms Leadership

By

Embracing Total Responsibility In every organization there comes a moment when teams must choose...

Read the latest Blogs

Forums

What Makes a Blockchain Development Company Essential for Modern Businesses?

By vegavidtech

A blockchain development company helps businesses leverage decentralized technology to improve transparency, security, and...

How to resolve issue of custom Audit log table containing incorrect data?

By Kevin8

We have created a parent table, child table & Audit log table in SQL...

Change Tracking Default Retention

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Change Tracking Default Retention

Visit the forum

Question of the Day

Change Tracking Default Retention

I run this command on my SQL Server 2022 database:

ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;
What is the default data retention period?

See possible answers