Dienstag, 7. Juli 2015

SQL Server: shrink all transaction logs in an instance



EXEC sp_msForEachDB 'PRINT ''
USE ?
GO
ALTER DATABASE ? SET RECOVERY SIMPLE
GO
DBCC SHRINKFILE(''''?_log'''',1)
GO
ALTER DATABASE ? SET RECOVERY FULL
GO''
'

Keine Kommentare: