SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Old Forums
 CLOSED - General SQL Server
 Index corruption
 Forum Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

neena
Starting Member

10 Posts

Posted - 01/03/2002 :  22:04:14  Show Profile
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

India
25 Posts

Posted - 01/04/2002 :  02:24:26  Show Profile  Visit Rafiq's Homepage
Hi,


If you want more information about this, Go to following web site.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q298806

Regards,

Rafi
Go to Top of Page

neena
Starting Member

10 Posts

Posted - 01/04/2002 :  20:58:53  Show Profile
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????



Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

USA
3246 Posts

Posted - 01/05/2002 :  21:45:13  Show Profile  Visit AjarnMark's Homepage
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...
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.23 seconds. Powered By: Snitz Forums 2000