Search for questions :
My Profile
Categories

Stefen

Open Question Bookmark and Share

Shrink of Database in SQL Server 2000. ?

I have a SQL Database which is made in SQL Server 2000 Enterprise SP4. Whenever I tried to shrink my Database, I find the following error in it:
"Server: Msg 6107, Level 25, State 5, Line 2
Page (1:713), slot 3 for text, ntext, or image node does not exist. Connection Broken”
I had found that when I run the select command on sysindexes table I find the same error. How can this error removed?

275 day ago

    Comment(s) (0)
    Report Abuse
   Find Intereseting  
   E-Mail to Friends  
   Bookmark  
   Subscribe to Answer Alert  
No comments yet !!!     Be the first to comment
Answers (1)

Rachel 		You should run reindexing on the Database. Than you can run the checktable command. But if you still have the same error than you can make use of MDF Repair option to fix this Database problem. But before using the Repair options just look on that you are not loosing any of your saved databases. As the Sysindexes table cannot be repaired because it is System table. If by using the repair options also you are not getting the error removed than create a new Database and export all tables from existing database to the new one. This can prevent your database from any errors and problems.

Posted 275 days ago

( 0 )
( 0 )
    Comment(s) (0)
   Report Abuse
No comments yet !!! Be the first to comment on this answer !!!

Email this question link to friends
You must enter email-address, if name is entered and vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
Max Allowed : 5000 Characters Current Count : 0
  Your comment on this answer
Max Allowed : 5000 Characters Current Count : 0