Glossary | Contact | Favorites | Login
Enter the following TSQL:-USE [DBName]BACKUP LOG [DBName]WITH TRUNCATE_ONLYDBCC SHRINKFILE ([DBName]_log,1)Where [DBName] is the name of the database you wish to shrink the log file for
Last Updated7th of March, 2011
Print this page
Email this page
Post a comment
Subscribe me
Add to favorites
Remove Highlighting
Edit this Article
Quick Edit
Export to PDF
Thank you for rating this answer.
Knowledge Management Software by Interspire