Written by • January 14, 2010• 12:53 pm• Microsoft, SQL Server

Shrinking the Transaction Log in SQL Server 2005

HomeMicrosoft, SQL ServerShrinking the Transaction Log in SQL Server 2005
Tweet
Share
Share
WhatsApp
Pin
Share
Reddit
Pocket
Vote
Flip
Buffer
Email

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: , , , , , , , , , , Last modified: September 2, 2019

About the Author /

Thomas works as a Principal Program Manager & Chief Evangelist Azure Hybrid at Microsoft (Cloud + AI). He engages with the community and customers around the world to share his knowledge and collect feedback to improve the Azure hybrid cloud and edge platform. Prior to joining the Azure engineering team (Cloud + AI), Thomas was a Lead Architect and Microsoft MVP, to help architect, implement and promote Microsoft cloud technology. If you want to know more about Thomas, check out his blog: www.thomasmaurer.ch and Twitter: www.twitter.com/thomasmaurer

← Previous Story
Shrinking the Transaction Log in SQL Server 2000
→ Next Story
The Bing Bang Theory: Windows 7 is much more userfriendly than Windows Vista

Related Posts

Azure Arc Servers Log Analytics

Azure Log Analytics for Azure Arc Enabled Servers

July 14, 2020• Microsoft, Microsoft Azure, Windows Server • One Comment

In this blog post, we are going to have a quick look at how you can access Azure Log Analytics data using Azure Arc for Servers. The Azure...
Read More → Read More: Azure Log Analytics for Azure Arc Enabled Servers
Add Microsoft Monitoring Agent Extension

How to Add the Microsoft Monitoring Agent to Azure Arc Servers

July 9, 2020• Microsoft, Microsoft Azure, Windows Server • 3 Comments

To use some of the functionality with Azure Arc enabled servers, like Azure Update Management, Inventory, Change Tracking, Logs, and more,...
Read More → Read More: How to Add the Microsoft Monitoring Agent to Azure Arc Servers

Slipstream SQL Server 2008 SP2 for SCCM 2012

December 3, 2011• Microsoft, SQL Server, System Center, Windows Server • 2 Comments

The Release Candidate version of System Center Configuration Manager 2012 requires MS SQL Server 2008 SP2 with Cumulative update package...
Read More → Read More: Slipstream SQL Server 2008 SP2 for SCCM 2012

Shrinking the Transaction Log in SQL Server 2000

January 14, 2010• Microsoft, SQL Server

Here is how you Shrinking Transaction Log SQL Server 2000: Use the SQL Query Analyzer BACKUP LOG XXX WITH TRUNCATE_ONLY GO DBCC...
Read More → Read More: Shrinking the Transaction Log in SQL Server 2000

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.

Close Search Window
↑
Close