I ran into an issue recently with a log file that would not shrink. All the DB Truncates that I ran would not shrink it. The fix is to just detach the DB, rename the log file and reattach. That will create a new log file from scratch.
Detail are here
sp_detach_db [YourDatabaseName]
then
sp_attach_db @dbname = N‘YourDatabaseName’,
@filename1 = N‘D:\Microsoft SQL Server1\MSSQL\Data\YourDatabaseName.MDF’


0 Responses to “Force a truncation of a SQL log”
Leave a Reply
You must login to post a comment.