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)




© 2018 | Анна Петросян | pashelp@yandex.ru