Skip to content

Instantly share code, notes, and snippets.

@saninb

saninb/new_gist_file_0

Created October 2, 2016 08:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save saninb/e4576df821c51a4518a341e0b7574318 to your computer and use it in GitHub Desktop.
Save saninb/e4576df821c51a4518a341e0b7574318 to your computer and use it in GitHub Desktop.
Download ZIP
Truncate SQL Server log file
Raw
new_gist_file_0
ALTER DATABASE mydatabase SET RECOVERY SIMPLE
DBCC SHRINKFILE (mydatabase_Log, 1)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment