Skip to content

Instantly share code, notes, and snippets.

@pallid

pallid/Чистка журнала транзакции

Created November 6, 2015 07:21
Show Gist options
  • Save pallid/1e521816e1bb6add6f64 to your computer and use it in GitHub Desktop.
Save pallid/1e521816e1bb6add6f64 to your computer and use it in GitHub Desktop.
Download ZIP
Чистка журнала транзакции
Raw
Чистка журнала транзакции
USE [HRM]
ALTER DATABASE [HRM]
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (N'HRM_log', 4100) -- 100 кол-во мб
GO
ALTER DATABASE [HRM]
SET RECOVERY FULL;
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment