Обрезка логов MSSQL

Обрезка логов MSSQL
use zup
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE "zup"
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.-- Shrink the truncated log file to 1 MB.
--Name Log file it`s a Logical Name File, not physical
DBCC SHRINKFILE (zup_log, 1);
--GO
--SET RECOVERY FULL;