17
- April
2014
Posted By : Alexander Goida
Truncate log file of a MSSQL database

From time to time it’s required to clean up log file, but Managment Studio does not offer straightforward command to do that. This script will help in cleaning up.

LogFileName – a system name of the log file, which can be taken from DB properties or system table sys.database_files

 

Category:

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.