May 9, 2009 at 7:23 am
Hello friends, need some help. I am backing up data with Data Protection Manager but having some errors the errors are listed below.
Backup- IHS-MAIN-SQL-03 An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P107'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P106'.
Backup- IHS-MAIN-SQL-05 An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P83'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P61'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P60'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P56'.
An unknown or unexpected database error occurred while attempting a DBCC.
DBCC results for 'P54'.
someone told me to use DBCC UPDATESTATUS but if it is correct what parameters should i use with it and how? help me pease
May 9, 2009 at 2:04 pm
Please run the following on that database and post the full results.
DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 9, 2009 at 2:52 pm
I get this error:-
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "lab_test", index ID 0, partition ID 70667134631936, alloc unit ID 70667134631936 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'lab_test' (object ID 1078294901).
Msg 2508, Level 16, State 3, Line 1
The In-row data RSVD page count for object "image_regions", index ID 0, partition ID 72171321950208, alloc unit ID 72171321950208 (type In-row data) is incorrect. Run DBCC UPDATEUSAGE.
CHECKDB found 0 allocation errors and 1 consistency errors in table 'image_regions' (object ID 1101246978).
but give me syntax for DBCC UPDATEUSAGE.
I KNOW ITS DBCC UPDATEUSAGE but what parameter should i give after UPDATEUSAGE.
May 10, 2009 at 3:31 am
Just run it with no parameters in the database in question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 10, 2009 at 5:08 am
Wait!!! but you are saying you are trying to backup the database? then why is it running DBCC?
May 10, 2009 at 6:09 am
Run DBCC Checkdb and post what is the message you are getting
May 10, 2009 at 6:34 am
Swayambhu narayan Samamtroy (5/10/2009)
Run DBCC Checkdb and post what is the message you are getting
He already has. See the third post in this thread.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply