Link to home
Start Free TrialLog in
Avatar of vera2006
vera2006Flag for Sweden

asked on

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.
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

What is the size of the data file and what is the size of the Transaction Log?
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial