Skip to content

Instantly share code, notes, and snippets.

@alexruzenhack

alexruzenhack/cut-sqlserver-log.sql

Last active November 27, 2018 14:30
Show Gist options
  • Save alexruzenhack/41e4f2b0167df417e465080a5aabee71 to your computer and use it in GitHub Desktop.
Save alexruzenhack/41e4f2b0167df417e465080a5aabee71 to your computer and use it in GitHub Desktop.
Download ZIP
✂️ Shrink log file of #sqlserver
Raw
cut-sqlserver-log.sql
USE [nomeSeuBancoDeDados];
CHECKPOINT;
GO
CHECKPOINT; -- run twice to ensure database file wrap-around last transactions
GO
-- 200 MB
DBCC SHRINKFILE(nomeSeuBancoDeDados_log, 200);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment