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,994 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

Automating SQL Maintenance: How DevOps Principles Reduce Downtime

By

In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...

From Couch-Potato to Triathlete – and What This Means for Your SQL Server

By

Do you know if your SQL Server is really running at its best? To...

Retro Data 2025 – Slidedeck

By

You can find the slides of my session on the €100 DWH in Azure...

Read the latest Blogs

Forums

Single User SQL Server on Linux

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Single User SQL Server on...

All the Costs of Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item All the Costs of Downtime

How Well Does the MSSQL Extension in VSCode Work?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item How Well Does the MSSQL...

Visit the forum

Question of the Day

Single User SQL Server on Linux

How can I start SQL Server on Linux in single-user mode to restore the master database?

See possible answers