SLOT 1 for text, ntext, or image node does not exist
-
Hi,
The corruption in the database is that in one of the tables a column containing data value TEXT cannot be accessed, everything else in database works fine… When running a select on that column it returns “SLOT 1 for text, ntext, or image node does not exist”
What caused the corruption was that a Fulltext index was being moved to another disk, that disc crashed while moving the fulltext index….
The last working backup we got is 4 month old which means we are missing approx 20 000 rows…
We have restored the old database and are thinking it might help to copy the sysindex tables from the old working to the corrupt one…
Any thoughts on this idea?
-
This was removed by the editor as SPAM
-
Hi,
Is this the exact error message ?
Did you checked SQL Server error log? Is there any assertion or access violation error generated in the SQL Server error log.
What is the SQL Server version? Run @@version in QA.
Try to run DBCC CHECKDB on the database.
Do let me know further..."More Green More Oxygen !! Plant a tree today"
-
I have the same problem in sql2000?
Page (1:928392), slot 9 for text, ntext, or image node does not exist
when I run the command
dbcc traceon(3604)
dbcc page ('databasename', 1,928392 , 3)
it show data for all other slot except slot 9???
greatly appreciate if someone post a solution .
regards
KN
-
Your database is corrupt. You need to restore from your backups (or failing that, run repair).
Are you running regular DBCC CHECKDBs and this just occured, or is this a one-off CHECKDB that picked this up?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply