T-SQL | Cut Transaction Log

use db_name

backup log db_name with truncate_only

use db_name

DBCC SHRINKFILE (db_name_Log, 500)

Например (БД AdventureWorks):

use AdventureWorks

backup log AdventureWorks with truncate_only

use AdventureWorks

DBCC SHRINKFILE (AdventureWorks_Log, 500)