Advertisement
private775

SQL: truncate all LOG files

Jan 26th, 2016
320
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. SELECT
  2.       'USE [' + d.name + N']' + CHAR(13) + CHAR(10)
  3.     + 'DBCC SHRINKFILE (N''' + mf.name + N''' , 0, TRUNCATEONLY)'
  4.     + CHAR(13) + CHAR(10) + CHAR(13) + CHAR(10)
  5. FROM
  6.          sys.master_files mf
  7.     JOIN sys.databases d
  8.         ON mf.database_id = d.database_id
  9. WHERE d.database_id > 4 and mf.type_desc = 'LOG'
  10. and d.recovery_model_desc = 'SIMPLE'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement