Thomas Maurer

Cloud and Datacenter Blog focusing on Microsoft Azure

Subscribe
,

Shrinking the Transaction Log in SQL Server 2005

Thomas Maurer
Updated
1–2 minutes
No comments on Shrinking the Transaction Log in SQL Server 2005

Shrinking the Transaction Log in SQL Server 2005
Use the MS SQL Server Management Studio

EXEC sp_dboption 'XXX', 'trunc. log on chkpt.', 'TRUE'

CHECKPOINT

DBCC SHRINKFILE ('XXX_Log', TRUNCATEONLY)

EXEC sp_dboption 'XXX', 'trunc. log on chkpt.', 'FALSE'

GO

(replace XXX with the database name)

Tags, , , , , , , , , ,
Thomas Maurer
Thomas is the EMEA Global Black Belt (GBB) for Sovereign Cloud at Microsoft, helping organizations across the region harness Microsoft’s sovereign, hybrid, multicloud, and edge solutions. He works directly with C-level leaders and technical teams to remove roadblocks, accelerate digital transformation, and shape long-term cloud strategies that meet business and regulatory needs. With over 15 years of experience in cloud and datacenter, including his previous role as Principal Program Manager and Chief Evangelist for Azure Hybrid, he combines deep technical expertise with a passion for customer success. He specializes in creating scalable architectures, solution accelerators, and thought leadership that drive adoption and innovation on Azure. Thomas is a passionate community advocate and frequently speaks at industry events such as Microsoft Ignite and Microsoft TechDays. He shares his expertise through his Cloud and Datacenter Blog at www.thomasmaurer.ch and on LinkedIn and X.com www.twitter.com/thomasmaurer.

Related articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.