DECLARE @script nvarchar(4000) SET @script = ' IF ''?'' NOT IN (''tempdb'',''master'',''model'',''msdb'') BEGIN USE [?] DECLARE @tsql nvarchar(4000) SET @tsql = '''' DECLARE @logFile int DECLARE LogFiles CURSOR FOR SELECT fileid FROM sysfiles WHERE status & 0x40 = 0x40 OPEN LogFiles FETCH next FROM LogFiles INTO @logFile WHILE @@fetch_status = 0 BEGIN SET @tsql = @tsql + ''DBCC SHRINKFILE('' + cast(@logFile AS varchar(5)) + '', 1)'' + CHAR(13) + CHAR(10) FETCH next FROM LogFiles INTO @logFile END CLOSE LogFiles DEALLOCATE LogFiles SET @tsql = @tsql + ''BACKUP LOG [?] WITH TRUNCATE_ONLY'' + CHAR(13) + CHAR(10) + @tsql EXEC(@tsql) END' EXEC sp_msforeachdb @script
Shrink Log Files
Suscribirse a:
Enviar comentarios (Atom)
No hay comentarios:
Publicar un comentario