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'
---------保留一個月的歷史記錄
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24867586/viewspace-716203/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24867586/viewspace-716203/