Wednesday, March 7, 2012

DBCC DBREINDEX is failing

I am currently perplexed by the following error I receive when running
DBCC DBREINDEX
Msg 605, Sev 21: Attempt to fetch logical page (1:193369) in database
'SNLEDIT' belongs to object 'FinlAvgCalc2', not to object 'Instn'.
[SQLSTATE HY000]
I have many databases that I run a job that reindexes all tables the
command is
DBCC dbreindex(@.name,'', 95)
A couple of weeks ago one of the databases began failing with the above
error msg. The tables effected always varies. I am concerened since I
thought the reindex command was used to prevent the above condition.
Does anyone have any ideas on a workaround for this condition.
Your help is greatly appreciated.
Dan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi Dan,
Try running DBCC CHECKDB on the affected database and see if that comes up
with any errors. This will probably take quite a long time to run though.
Jacco Schalkwijk
SQL Server MVP
"Dan Duncan" <dduncan@.snl.com> wrote in message
news:ezjLgqK8DHA.3420@.TK2MSFTNGP11.phx.gbl...
>
> I am currently perplexed by the following error I receive when running
> DBCC DBREINDEX
> Msg 605, Sev 21: Attempt to fetch logical page (1:193369) in database
> 'SNLEDIT' belongs to object 'FinlAvgCalc2', not to object 'Instn'.
> [SQLSTATE HY000]
> I have many databases that I run a job that reindexes all tables the
> command is
> DBCC dbreindex(@.name,'', 95)
> A couple of weeks ago one of the databases began failing with the above
> error msg. The tables effected always varies. I am concerened since I
> thought the reindex command was used to prevent the above condition.
> Does anyone have any ideas on a workaround for this condition.
> Your help is greatly appreciated.
> Dan
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!|||Thanks for the response. Once a week I run
DBCC CHECKDB (@.dbname) WITH ALL_ERRORMSGS
and I get the following result
CHECKDB found 0 allocation errors and 0 consistency errors in database
'SNLEDIT'. [SQLSTATE 01000]
When the errors started happening I would run
dbcc checktable
on the two tables in the error msg and always receive the following
DBCC results for 'FinlAvgCalc2'.
There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
with no errors reported.
Any additional ideas would be greatly appreciated.
Thanks
Dan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Thanks for the response. Once a week I run
DBCC CHECKDB (@.dbname) WITH ALL_ERRORMSGS
and I get the following result
CHECKDB found 0 allocation errors and 0 consistency errors in database
'SNLEDIT'. [SQLSTATE 01000]
When the errors started happening I would run
dbcc checktable
on the two tables in the error msg and always receive the following
DBCC results for 'FinlAvgCalc2'.
There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
with no errors reported.
Any additional ideas would be greatly appreciated.
Thanks
Dan
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!|||Do the whole db not just those tables. Try running DBCC CHECKDB and DBCC
CHECKCATALOG
Andrew J. Kelly
SQL Server MVP
"Dan Duncan" <dduncan@.snl.com> wrote in message
news:uv3Bc2L8DHA.3008@.TK2MSFTNGP09.phx.gbl...
> Thanks for the response. Once a week I run
> DBCC CHECKDB (@.dbname) WITH ALL_ERRORMSGS
> and I get the following result
> CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'SNLEDIT'. [SQLSTATE 01000]
> When the errors started happening I would run
> dbcc checktable
> on the two tables in the error msg and always receive the following
> DBCC results for 'FinlAvgCalc2'.
> There are 400030 rows in 80008 pages for object 'FinlAvgCalc2'.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> with no errors reported.
> Any additional ideas would be greatly appreciated.
> Thanks
> Dan
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment