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

asked on

MSSQLServer 2005 msdd

My msdblog.ldf is over 16 GB. I tryed to do a dbcc checkdb and a dbcc checkalloc on the msdb database but I received a latch 3 timeout error,I tryed to do a backup and I received the same latch 3 timeout error. I moved the msdb.mdf and the msdlog.ldf to another disk and tryed to do the same things again but I received the same latch 3 time-out error. I checked my query exection in the Microsoft SQL Server management Studio and the exection time-out is set to 0. I upgrade my service pack 2 to service pack 3 and tryed to do all the above but I still got latch 3 time-out error. I am wondering if someone can please help me solve this problem.
Many thanks in advance. Error code:A database snapshot cannot be created because it failed to start.
Msg 7928, Level 16, State 1, Line 1
The database snapshot for online checks could not be created. Either the reason is given in a previous error or one of the underlying volumes does not support sparse files or alternate streams. Attempting to get exclusive access to run checks offline.
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
Msg 845, Level 17, State 1, Line 1
Time-out occurred while waiting for buffer latch type 3 for page (1:708), database ID 4.
ASKER CERTIFIED SOLUTION
Avatar of Shinesh Premrajan
Shinesh Premrajan
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
SOLUTION
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
Avatar of vera2006

ASKER

When I do a dbcc checkdb with tablock on my msdb I received the following error:
Msg 5030, Level 16, State 12, Line 1
The database could not be exclusively locked to perform the operation.
Msg 7926, Level 16, State 1, Line 1
Check statement aborted. The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected and what workarounds exist. Also see previous errors for more details.
SOLUTION
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