October 19, 2008 at 8:00 pm
Can a Fragmented Index turn a table in suspect mode?
We have a database which mode became suspect. What we did is take the database offline and make it online again then the database became available. When viewing the index in the database we saw 1 fragmented index (99%) so I ask this question just to check if this can be a factor
"-=Still Learning=-"
Lester Policarpio
October 20, 2008 at 2:13 am
Please put the question in the post, not the header. The header gets trimmed at a certain length.
Fragmentation is just concerned with the order of pages in an index. It won't cause corruption or anything else. Those are typically caused by hardware problems.
Can you explain your problem in more detail please?
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply