The Artima Developer Community
Articles | News | Weblogs | Books | Forums
Artima Forums | Articles | Weblogs | Java Answers | News
Sponsored Link •

.NET Buzz Forum
Shrinking the Transaction Log

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Merill Fernando

Posts: 589
Nickname: merill
Registered: Sep, 2003

Merill Fernando is an MCSD in .NET and a Microsoft Certfied Trainer
Shrinking the Transaction Log Posted: Jun 1, 2004 4:30 AM
Reply to this message Reply

This post originated from an RSS feed registered with .NET Buzz by Merill Fernando.
Original Post: Shrinking the Transaction Log
Feed Title: Merill Fernando's Blog
Feed URL: http://www.merill.net/blogxbrowsing.asmx/GetRss?
Feed Description: Merill is a Software Architect at Business Technology Alliance. Merilll is an MCSD in .NET and a Microsoft Certfied Trainer. In this feed he will be regularly posting on the challenges faced when migrating from a Microsoft DNA architecture to Microsoft .NET 		Latest .NET Buzz Posts
Latest .NET Buzz Posts by Merill Fernando
Latest Posts From Merill Fernando's Blog

Advertisement

 To shrink the transaction log run the following SQL statement on the database.

 

DBCC SHRINKFILE(WS20FCM_Log, 2)

 

To truncate the log use the following and run the shrink command again:

 

BACKUP LOG WS20FCM WITH TRUNCATE_ONLY

DBCC SHRINKFILE(WS20FCM_Log, 2)

 

MS: Shrinking the Transaction Log in SQL Server 2000 with DBCC SHRINKFILE

 

Read: Shrinking the Transaction Log

Topic: The Regulator 2.0.2 Previous Topic   Next Topic Topic: Longhorn Speech API Article
Sponsored Links


Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use