The article has been updated successfully.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
- Polling - Configuring Connections
- Polling - Configuring Schedules
- Check Databases For Corruption
- Check Database For Collation
- Creating an Article - Content
Attachments
No attachments were found.Visitor Comments
Article Details
Last Updated
7th of March, 2011
Would you like to...
User Opinions
100%
0%
(5 votes)