declare @dt datetime select @dt = cast(N'2012-01-14T09:25:43' as datetime)
exec msdb.dbo.sp_delete_backuphistory @dt
GO
EXEC msdb.dbo.sp_purge_jobhistory  @oldest_date='2012-01-14T09:25:43'
GO
EXECUTE msdb..sp_maintplan_delete_log null,null,'2012-01-14T09:25:43'

---------保留一個月的歷史記錄