Error Msg
in [Server Configuration]
|
From: Muhammad Bilal on 17 May 2010 12:36 Hi. When I drop the table through query or enterprise manager in sql server 2000 it gives the following error “Server: Msg 7105, Level 22, State 3, Line 1 Page (1:1424), slot 0 for text, ntext, or image node does not exist. Connection Broken” There is no column with the data type text, ntext or image is in table and no foreign key only a composite primary key is on the table. But data in the table can be modified, deleted or modified. Dbcc checkdb also raises error “Server: Msg 8929, Level 16, State 1, Line 1 Object ID 2: Errors found in text ID 2655486279680 owned by data record identified by RID = (1:377:11) id = 1142295129 and indid = 10. Server: Msg 8965, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:1424), slot 0, text ID 2655486279680 is referenced by page (1:1410), slot 7, but was not seen in the scan. Server: Msg 8964, Level 16, State 1, Line 1 Table error: Object ID 2. The text, ntext, or image node at page (1:1427), slot 2, text ID 2655486279680 is not referenced.” Regards, Muhammad Bilal
From: Erland Sommarskog on 17 May 2010 17:24 Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes: > When I drop the table through query or enterprise manager in sql server > 2000 it gives the following error > �Server: Msg 7105, Level 22, State 3, Line 1 > Page (1:1424), slot 0 for text, ntext, or image node does not exist. > Connection Broken� > > There is no column with the data type text, ntext or image is in table and > no foreign key only a composite primary key is on the table. > > But data in the table can be modified, deleted or modified. > > Dbcc checkdb also raises error > �Server: Msg 8929, Level 16, State 1, Line 1 > Object ID 2: Errors found in text ID 2655486279680 owned by data record > identified by RID = (1:377:11) id = 1142295129 and indid = 10. > Server: Msg 8965, Level 16, State 1, Line 1 > Table error: Object ID 2. The text, ntext, or image node at page (1:1424), > slot 0, text ID 2655486279680 is referenced by page (1:1410), slot 7, > but was not seen in the scan. > Server: Msg 8964, Level 16, State 1, Line 1 > Table error: Object ID 2. The text, ntext, or image node at page (1:1427), > slot 2, text ID 2655486279680 is not referenced.� You have now posted the same question four times, despite that John Bell answered already your first. Did you look at http://support.microsoft.com/kb/892803/? Was it applicable? -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: Muhammad Bilal on 18 May 2010 12:24 My question was not dislayed in the forum due to which i posted it several times. No the reply from John Bell was not helpful. I checked and found the problem is in sysindexes. So now what should i do. Regards, Muhammad Bilal "Erland Sommarskog" wrote: > Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes: > > When I drop the table through query or enterprise manager in sql server > > 2000 it gives the following error > > “Server: Msg 7105, Level 22, State 3, Line 1 > > Page (1:1424), slot 0 for text, ntext, or image node does not exist. > > Connection Broken” > > > > There is no column with the data type text, ntext or image is in table and > > no foreign key only a composite primary key is on the table. > > > > But data in the table can be modified, deleted or modified. > > > > Dbcc checkdb also raises error > > “Server: Msg 8929, Level 16, State 1, Line 1 > > Object ID 2: Errors found in text ID 2655486279680 owned by data record > > identified by RID = (1:377:11) id = 1142295129 and indid = 10. > > Server: Msg 8965, Level 16, State 1, Line 1 > > Table error: Object ID 2. The text, ntext, or image node at page (1:1424), > > slot 0, text ID 2655486279680 is referenced by page (1:1410), slot 7, > > but was not seen in the scan. > > Server: Msg 8964, Level 16, State 1, Line 1 > > Table error: Object ID 2. The text, ntext, or image node at page (1:1427), > > slot 2, text ID 2655486279680 is not referenced.” > > You have now posted the same question four times, despite that John Bell > answered already your first. Did you look at > http://support.microsoft.com/kb/892803/? Was it applicable? > > > > -- > Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se > > Links for SQL Server Books Online: > SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx > SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx > SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx > > . >
From: Erland Sommarskog on 18 May 2010 17:33 Muhammad Bilal (MuhammadBilal(a)discussions.microsoft.com) writes: > My question was not dislayed in the forum due to which i posted it several > times. > > No the reply from John Bell was not helpful. I checked and found the > problem is in sysindexes. So now what should i do. The message indicates serious corruption. If you have a clean backup, restore the backup. Else rebuild the database from scripts if possible, and bulk out data from the old database and load into the new database. Make sure that you don't build the new database on the same disks as the source database, but consider those disks as tainted. Corruption is usually due to hardware errors. Of course, it is still possible that the steps outlined in the KB article, and it can be worth trying, since that is a far lease harsh cure than what I suggest. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
|
Pages: 1 Prev: sql200 SQLSERVERAGENT service won't start Next: sql200 SQLSERVERAGENT service won't start |