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


No Comments

You can leave the first : )

Leave a Reply