WinTill :: Knowledge Base



Shrinking A Database Log File

Enter the following TSQL:-

USE [DBName]

BACKUP LOG [DBName]
WITH TRUNCATE_ONLY

DBCC SHRINKFILE ([DBName]_log,1)


Where [DBName] is the name of the database you wish to shrink the log file for



Related Articles

Attachments

No attachments were found.

Visitor Comments

Article Details

Last Updated
7th of March, 2011

Would you like to...

Print this page  Print this page

Email this page  Email this page

Post a comment  Post a comment

 Subscribe me

Subscribe me  Remove from favorites

Remove Highlighting Remove Highlighting

Edit this Article

Quick Edit

Export to PDF


User Opinions

100% thumbs up 0% thumbs down (5 votes)

How would you rate this answer?




Thank you for rating this answer.

Continue