I have a database that is showing quite a few rid errors in the event
logs...I know this is not a good thing, however I was able to restore a
good backup which at this point that seems to be clean.
My question is: Can anyone explain, or point me to a website that
explains in detail what exactly rid errors are. I know they can be
caused by a number of things such as a pc crashing or a bad hard drive.
ThanksYes, you can fix this problem. It is not seroius problem but it could be if you left it as is.
This error may occur, as you say 'pc crashing or a bad hard drive' and it means that Row identifier is not pointing to the wright row any more. Usualy you could solve this problem by issuing DBCC CHECKDB, and if not try to rebuild indexes on specific table with DBCC DBREINDEX. Certainly you should check hardware : disk, power.... bacause this error IS "hardware error"
Hope it Helpssql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment