January 16, 2009 at 3:36 am
Hi,
I am new to SQL, I have a maintainece failing to run. The task is running daily and I havnt noticed any issues, howerver its not running for last 2 days. Can some one please help me. Below is the log file detail.
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.2047
Report was generated on "COLMVTEST".
Maintenance Plan: User DB MaintenancePlan
Duration: 00:29:17
Status: Warning: One or more tasks failed..
Details:
Check Database Integrity (COLMVTEST)
Check Database integrity on Local server connection
Databases: All user databases
Include indexes
Task start: 15/01/2009 22:01.
Task end: 15/01/2009 22:30.
Failed:(-1073548784) Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "Time-out occurred while waiting for buffer latch type 2 for page (1:45184), database ID 12.
The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:USE [ReportServer]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [ReportServerTempDB]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [AuditTrail171]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [MultiIndex171]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [staging]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [MultiIndex]
GO
DBCC CHECKDB WITH NO_INFOMSGS
GO
USE [AuditTrail]
GO
DBCC CHECKDB WITH NO_INFOMSGS
Thank you
Junaid
January 16, 2009 at 7:18 am
Check out this thread, http://www.sqlservercentral.com/Forums/Topic305986-92-2.aspx
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
January 16, 2009 at 7:59 am
That thread is indicating to restart the server I think. I will need to do that out of office hours. Thank you hopefully it will resolve the issue
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply