ms sql 2012 truncate log

[admin]

Код: Выделить всё

USE storedb;
ALTER DATABASE storedb SET RECOVERY SIMPLE;
DBCC SHRINKFILE('storedb_log', 0, TRUNCATEONLY);
ALTER DATABASE storedb SET RECOVERY FULL;