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

Shrinking the Transaction Log in SQL Server 2000

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

Here is how you Shrinking Transaction Log SQL Server 2000:

  • Use the SQL Query Analyzer
BACKUP LOG XXX WITH TRUNCATE_ONLY
GO
DBCC SHRINKFILE(XXX_log, 10)
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

← SCVMM Logical Switch Hyper-V Host vNIC Live Migration Previous Story
P2V Hyper-V Migration
→ Next Story
Shrinking the Transaction Log in SQL Server 2005

Related Posts

Bring Azure innovation to your SQL Server anywhere with Azure Arc

Bring Azure innovation to your SQL Server anywhere with Azure Arc

November 15, 2023• Microsoft Azure, SQL Server

Bring Azure innovation to your SQL Server anywhere with Azure Arc. In this video I had the chance to speak to Dhananjay Mahajan Principal...
Read More → Read More: Bring Azure innovation to your SQL Server anywhere with Azure Arc
End of Support Windows Server 2012 Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack

Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack

December 7, 2021• Microsoft, Microsoft Azure, SQL Server, Windows Server • One Comment

Windows Server is an essential workload platform for almost every organization, and is one of the most popular operating systems in Azure....
Read More → Read More: Extended Security Updates for Windows Server and SQL Server in Azure and Azure Stack
Azure Arc enabled Data services video series

Azure Arc enabled Data services video series

August 31, 2021• Microsoft, Microsoft Azure

With Azure Arc we are not just allowing you to use the Azure control plane to manage resources like servers and Kubernetes clusters outside...
Read More → Read More: Azure Arc enabled Data services video series
Azure Arc Jumpstart

Get started with the Azure Arc Jumpstart Project

December 17, 2020• Microsoft Azure

Yesterday the team announced the new Azure Arc Jumpstart project. We all have been there, and you want to try out some new Azure services...
Read More → Read More: Get started with the Azure Arc Jumpstart Project

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