Blogs
September 08, 2008
Filter by Category
Blogs
Jun 14

Written by: Thomas Hundley
6/14/2008 8:48 PM

 

I only need to do this every so often, but I always forget how to and end up looking it up.  Thus, I'm posting it here for reference.

 

 

USE DatabaseName

GO

BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(<TransactionLogName>, 1)

Tom Hundley
Elegant Software Solutions, LLC

Tags:

Your name:
Title:
Comment:
Add Comment    Cancel  
Home  |  About Us  |  Services  |  Methodology  |  Clients  |  Careers  |  Blogs  |  Contact Us  |  Portal Login
Copyright© Elegant Software Solutions, LLC