how to shrink transaction log
DBCC SHRINKFILE(starhonda_log, 2)
BACKUP LOG starhonda WITH TRUNCATE_ONLY
DBCC SHRINKFILE(starhonda_log,2)
permanent link
posted by Michael I. Buen @ 5:31 PM
0 comments
avoiding the hazards of code redundancy since 93
The perfect is the enemy of the good.
My Fave Links- A gentle introduction to SQL
- Inquirer 7
- Planet Source Code
- DevX
- Programmers Heaven
- Free VB Code
- VB Accelerator
- VB Helper
- VB City
- VBNet Visual Basic Resource Center
- Blackbelt VB
- C# Station
- C# on Linux
- C# Tutorial
- gizmag
- undextrois' programming anecdotes and code snippets
- My latest blog
- IRC - Quakenet Server, #tayotayolang
- Skype Me
- Yahoo Message Me
- Mail Me
- Yahoo Call Me
- Web-based typing speed test
Previous Posts
- Becoming a Millionaire -- A Real-Life Example
- The Power of Compound Interest
- C# NET 2.0, Formatting and Validating Data
- FAQ: How to recursively adjust file and directory ...
- how to query analyzer within command line
- postgresql on ubuntu
- computer whiz woes
- ONLINE ORIGINAL: Carlos Slim: "The Key Is the Inte...
- Slashdot | HardOCP Spends 30 Days With Vista
- Chris Taylor : Remoting Exceptions
Archives
- November 2004
- December 2004
- January 2005
- February 2005
- March 2005
- April 2005
- May 2005
- June 2005
- July 2005
- August 2005
- September 2005
- October 2005
- November 2005
- December 2005
- January 2006
- February 2006
- March 2006
- April 2006
- May 2006
- October 2006
- December 2006
- February 2007
- March 2007
- April 2007
- May 2007
- July 2007
- December 2007
- January 2008
- October 2008
Saturday, February 24, 2007
BACKUP LOG starhonda WITH TRUNCATE_ONLY
DBCC SHRINKFILE(starhonda_log,2)