Sign in | Join | Help

ASP.NET,C#, Web Service, OOD

Ludmal's Blog

This Blog

  • Home

Syndication

  • RSS for Posts
  • Atom
  • RSS for Comments

Search

  • Go

Community

  • Home
  • Blogs
  • Media
  • Forums
  • FAQ's

Archives

  • June 2009 (1)
  • May 2009 (1)
  • April 2009 (1)
  • March 2009 (1)
  • February 2009 (1)
  • January 2009 (1)
  • January 2008 (2)
  • April 2007 (2)
  • March 2007 (1)
  • December 2006 (1)
  • October 2006 (3)
  • September 2006 (1)
  • August 2006 (3)
  • July 2006 (2)
  • June 2006 (3)
  • May 2006 (7)
  • April 2006 (5)
  • March 2006 (5)
  • February 2006 (5)
  • January 2006 (7)
  • December 2005 (10)
  • November 2005 (6)

Blogs I Read

  • Dinesh's Blog
  • Madhawa
  • Mahasen
  • Sumudu
  • Wela(MVP)
  • William Tay
  • Rob Howard
  • Prasanna(MVP)
  • Dino Esposito
  • Howard Lo
  • Manzi (MVP)

December 2006 - Posts

12-08-2006 9:29 AM

Sql Transaction Log file

To shrink your sql transaction log file, do this....

BACKUP LOG www_redgreen_com TO DISK = 'c:\www_redgreen_com.bak' WITH TRUNCATE_ONLY
DBCC SHRINKFILE (RedGreen_log)
Posted by Ludmal De Silva | with no comments
 
Copyright © Sri Lanka .NET Forum. All Rights Reserved. Terms of Use | Privacy Policy