Limpar logs do Database Mail
EXEC msdb.dbo.sysmail_delete_log_sp
GO
--------------------------------------------------
Limpar histórico de trabalho
-- example removes the history for a job named NightlyBackups.
USE msdb
GO
EXEC dbo.sp_purge_jobhistory @job_name = N'NightlyBackups'
GO
---------------------------------------------------
Script apagando todos os logs do histórico dos jobs.
|
1
2
3
4
5
|
USE msdbGO EXEC dbo.sp_purge_jobhistory ;GO |
Script para apagar todos os logs do histórico dos jobs mantendo os últimos 30 dias
|
1
2
3
4
5
|
DECLARE @Data DATETIMESET @Data = GETDATE() - 30EXEC MSDB.DBO.SP_PURGE_JOBHISTORY@oldest_date=@Data |
Limpar arquivo de log
USE racom;
GO
ALTER DATABASE racom SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE ('racom_log', 1);
GO
ALTER DATABASE racom
SET RECOVERY FULL;
GO
