I have a very large database, in wich the indexes are constantly "getting lost". I execute DBCC Reindex and everything goes back to normal. Still, I don't know why this happens. I have to run this process once or twice a week, sometimes as a scheduled task, some others manually.
Why are the indexes 'getting lost'?
What could be wrong with the database?
Thanks in advance
Can you elaborate on what you mean by "indexes are getting lost"...are you saying the index no longer exists? That cannot be the case because dbcc reindex implies you have an index that is being reindexed.
Thx
Ajay
|||I'm deeply sorry for not being able to put this in other way. It's just that i do not understand what is happening, even less how to ask it or explain it... someone told me that "the indexes get corrupted". Still, I don't know what this means, or why...
Thans again
Eduardo
|||You might find some help with the DBCC commands. They will help you with physical and logical errors. Here is a good link for an introduction to those:
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=30&rl=1
And here is a more in-depth explanation of the DBCC CHECKDB command:
http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx
No comments:
Post a Comment