SELECT file_id, name FROM sys.database_files

BACKUP LOG [databaseName]
TO DISK=‘nul:’ WITH STATS= 10

DBCC SHRINKFILE(‘templog’, 0, TRUNCATEONLY)

Leave a Reply