In-row data USED page count

Question

In-row data USED page count

Suneetha_k

SSC Veteran

Points: 220
More actions
May 24, 2010 at 6:28 am

#156977

Hi I am getting error.
We have moved a database from one server to another server. both the servers are SQL Server 2005. but when i am executing maintenance plan i am getting below error:
The In-row data USED page count for object "DupTagRef", index ID 0, partition ID 54208101875712, alloc unit ID 54208101875712 (type In-row data) is incorrect
could you please help me out in order to resolve this issue. as the related job is failing every week. when i am using dbcc updateusage command everything seems ok but not without that

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

Have you run DBCC CHECKDB on this database?

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

What's the exact version of SQL that you are running? There were bugs with the page usage metadata right up to SP3 iirc

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

As Gail has said, there was a bug related to this. Please verify that both servers are running the same service pack level - update to sp3 if applicable. Then, as Grant said, run checkdb if you are still getting the error.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Suneetha_k SSC Veteran Points: 220 More actions · Answer 4

Hi All,

Thanks for the replies. I am having SQL Server 2005 SP3 on both the servers

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Please run the following on both servers and post the full and complete results.

SELECT @@version

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

We walk in the dark places no others will enter
We stand on the bridge and no one may pass