Technical Article

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 […]

You rated this post out of 5. Change rating

2005-10-28 (first published: )

390 reads

Blogs

T-SQL Tuesday #186–Agent Jobs

By

It’s that time of the month again, when the T-SQL Tuesday blog party takes...

SQL Saturday NYC Recap 2025

By

My first time at SQL Saturday New York City was an absolute blast! Thank...

SSMS 21

By

Just a quick one this morning. I’m on the road and haven’t worked up...

Read the latest Blogs

Forums

Azure Managed Instance Backups - Could Backup Be Completely Lost?

By BrainDonor

Some of our more regulated customers (banks, gambling sites and suchlike) like to know...

SSIS Automatically Coverting a NULL to a Blank Space

By cpiacente

Hello, I was wondering if anyone knew how to prevent this issue I am...

Problem creating a Linked Server to MS Access 97 database from SQL Server 2019

By Weegee71

Hi there I need help on creating a Linked Server to an MS Access...

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers