清除MSSQL历史记录

declare @dt datetime select @dt = cast(N'2019-05-21T14:13:45' as datetime) exec msdb.dbo.sp_delete_backuphistory @dt
GO
EXEC msdb.dbo.sp_purge_jobhistory  @oldest_date='2019-05-21T14:13:45'
GO
EXECUTE msdb..sp_maintplan_delete_log null,null,'2019-05-21T14:13:45'

原文地址:https://www.cnblogs.com/qiu18359243869/p/10905577.html