Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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 and mf.type_desc = 'LOG'
- and d.recovery_model_desc = 'SIMPLE'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement