Skip to content

Instantly share code, notes, and snippets.

@mirmostafa

mirmostafa/ClearDatabaseLog.sql

Created March 15, 2025 08:08
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save mirmostafa/33249990f67e82ba4bc2d8e9691d2fbb to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save mirmostafa/33249990f67e82ba4bc2d8e9691d2fbb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ClearDatabaseLog.sql
Use DATABASENAME
Alter Database DATABASENAME Set Recovery Simple
DBCC SHRINKFILE ('YOUR_LOG_NAME_log', 1)
Alter Database DATABASENAME Set Recovery Full
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment