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.developersdex.com ***
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.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

No comments:

Post a Comment