Transaction Log Will Not Truncate

I saw a posting recently of a DBA not being able to truncate a transaction log. I rememberred this script that I had, (downloaded from Microsoft Support many moons ago), which did the job for me. It basically filled the log with data, then truncated and shrank the log. All important points throughout the script […]

2005-10-28 (first published: )

382 reads

Blogs

Daily Coping 22 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Altering a Computed Column in a Temporal Table in Azure SQL

By

System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...

Basic OFFSET–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Office FOMO

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Office FOMO

Parquet

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Parquet

Permissions

By sqlguru

I am looking for option to truncate table since we don't need the logs...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Parquet

See possible answers