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: )

379 reads

Blogs

Simple Graph Queries

By

In this post we saw how to create some graph tables with data. In...

Quick Blog: Making the Power BI PowerShell cmdlets easier to use

By

One of the top reasons I love PowerShell so much is that from the...

Trouble writing? Join the club. #JustWriteTech

By

I was talking with  a couple of excellent SQL people* recently, and we were bemoaning...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Will the principal wait for acknowledgement from mirror?

By coolchaitu

Good Morning Experts, A transaction was sent to mirror database and immediately failover occured....

The log file of my user db is full. Please confirm if below resolves issue

By coolchaitu

Good morning experts, The log file of my user db is full. Could you...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers