Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
neena
Starting Member
10 Posts |
 Posted - 2002-01-03 : 22:04:14
|
| what are the possible reasons of index corruption in sql server 7.0 ???What points should be kept in mind while designing a database to avaoid index corruption??? |
|
|
Rafiq
Starting Member
25 Posts |
|
|
neena
Starting Member
10 Posts |
Posted - 2002-01-04 : 20:58:53
|
quote:
The problem is not upgrade to sql 2000. the index corruption has occurred in sql 7.0 when data is updated. The fields which get updated are not null fields. Are there any other reasons for this problem????
|
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-01-05 : 21:45:13
|
| Neena, your original questions were rather generic. There are several possible reasons for index corruption, not the least of which is some sort of hardware failure. Are you looking for a solution to a specific problem? How do you know your index is corrupt? Are you getting some sort of error message or just unexpected results? Have you tried removing the index and recreating it? When did this happen? What are the symptoms?--------------------------------------------------------------1000 Posts, Here I come! I wonder what my new title will be... |
|
|
|
|
|
|
Index corruption
Rafi