Mssqlserver 2005 system database

My msdb is 11GB, I tried to do a backup but I got "Time-out occurred while waiting for buffer latch type 3 for page (1:708), database ID 4." , I tried to shrink the log file I received the same timeout,I checked the execution time out and it's set to 0. I tried to do a dbcc checkdb on the msdb but I got the same timeout. What can I do with this msdb to reduce the size and get it working properly.
vera2006Asked:
Who is Participating?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Seems like msdb is piled with this information:

* Backup History
* Maintenance plan history
* Agent Jobs history

Just set some_value with any numeric value to purge or remove history information over a period of time..

declare @dt datetime
select @dt = getdate() - some_value
exec msdb.dbo.sp_delete_backuphistory @dt
GO
EXEC msdb.dbo.sp_purge_jobhistory  @oldest_date='2010-03-22T22:24:26'
GO
EXECUTE msdb..sp_maintplan_delete_log null,null,'2010-03-22T22:24:26'

Once done, take a full backup of msdb and then shrink your database or ldf file to a lower value.
0
 
Anthony PerkinsCommented:
What is the size of the data file and what is the size of the Transaction Log?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.