Use the following to truncate a log, the TestDbLog is the logical file name of the log file.
1 2 3 4 5 6 | USE TestDb GOALTER DATABASE TestDb SET RECOVERY SIMPLE WITH NO_WAITDBCC SHRINKFILE(TestDbLog, 1)ALTER DATABASE TestDb SET RECOVERY FULL WITH NO_WAITGO |
About Me