Litespeed jobs fail due to msdb being full
SQL Server table full
Did you have auto growth for db set?
The msdb database is used by SQL Server Agent for scheduling alerts and jobs and by other features such as Service Broker and Database Mail. By default, the auto growth is enabled for its data and log files. Since msdb database contains the history tables that store backup and restore activities, SQL Server Agent jobs, and database maintenance plans. If you never cleanup the history tables, it may make the msdb database full. To cleanup the history in the msdb database, you could use history cleanup task or execute the sp_purge_jobhistory and sp_delete_backuphistory.
Reference:
sp_delete_backuphistory
http://technet.microsoft.com/en-us/library/ms188328.aspx
sp_purge_jobhistory (Transact-SQL)
http://technet.microsoft.com/en-us/library/ms175044.aspx
History Cleanup Task (Maintenance Plan)
http://technet.microsoft.com/en-us/library/ms186524.aspx
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center