Howto shrink / truncate SQL transaction log file in SQL Server 2005

2 Replies

USE <databasename>

DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)

BACKUP LOG <databasename> WITH TRUNCATE_ONLY

DBCC SHRINKFILE(‘<logfilename-logical name>’, 1)

2 thoughts on “Howto shrink / truncate SQL transaction log file in SQL Server 2005”

Ulrich June 11, 2013 at 1:38 pm

Hej Kenneth,

Hvordan får man så lige Ahsay til at gøre dette efter hver fulde backup?
admin Post authorJune 11, 2013 at 2:34 pm

Skulle den vist gøre automatisk, bruger ikke ahsay længere, men prøv at spørge i deres forum.