Tracnac/Shrink Log SQLServer.md

Last active September 23, 2022 17:13

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/Tracnac/71ff6b35822a38e70bb29c27fb818931.js"></script>
Save Tracnac/71ff6b35822a38e70bb29c27fb818931 to your computer and use it in GitHub Desktop.

Download ZIP

Shrink Log SQLServer #mssql

Raw

Shrink Log SQLServer.md

-— Shrink Log Sqlserver ---
SELECT
'USE [' + d.name + N']' + CHAR(13) + CHAR(10)
+ 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)'
+ CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
FROM
sys.master_files mf
JOIN sys.databases d
ON mf.database_id = d.database_id
WHERE d.database_id > 4;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment