<< Deleting Records and Recovering Space in SQL Database | Microsoft SQL 2005 Version Guide >>

Flushing Transaction Logs and Recovering Space in SQL

by Joe Havelick 4. March 2008 09:24

The following script will truncate eveything from the SQL transaction log, and shrink the file.

--Truncate the Transcation log BACKUP LOG DatabaseName WITH NO_LOG ---Shrink the physical file with 10% reserve DBCC SHRINKDATABASE (DatabaseName, 10)

cf152ad4-bd75-41ef-957c-35cd8f207f8d|2|5.0

Tags: sql

Tech Tips

Deleting Records and Recovering Space in SQL DatabaseOn the occasion that you must removed data from a table and recover the space, there is a two step p...Determining SQL Table SizesWhen you need to understand where which tables are consuming the most space in your database, the fo...Restore All SQL Databases from a Backup FileAs part of a disaster recovery plan, I recently needed to have a script to restore all the dat...

Comments (1) -

3/30/2009 9:25:30 AM #

I realize this is an old entry.

Would you recommend backing up the log prior to running this script? I have an ~19GB log file that I would like to perform this on.

Regards

JoeHavelick.com

"Try to learn something about everything and everything about something." -Thomas H. Huxley

Flushing Transaction Logs and Recovering Space in SQL

Related posts

Comments (1) -

Add comment

About Me

Recommendations