corrput index syscomments...

[bruviken]

Hi gurus! I posted this problem at 'administration', but as I didn't get
any response, I thought I shold try here

It seems my syscomments is corrupt due to failure on a disk. However,
fixing the disk and running various dbcc commands will not fix the problem.


The error message says (in freehand, not cut-and-paste):
--->
Msg 2509, Level 16, State 2:
Server 'var_prod', Line 1:
Table Corrupt: The row number and offset of each row in the page should
have a matching entry in row number table; check this page (page#=11445
row#=0 offset in row number table=32)
Msg 2511, Level 1, State 1:
Server 'var_prod', Line 1:
Keys of index id 1 for table 'syscomments' in data page not in correct
order, Drop and re-create the index. (index page 11445)
<---

sp_fixindex returned this:
--->
Server Message: Number 605, Severity 16
Server 'dvhutv', Procedure 'sp_fixindex', Line 107:
An attempt was made to fetch logical page '257' in database 'master'
from cache 'default data cache'. Page belongs to object with id '45',
not to object 'sysdatabases'.
(1 row affected)
(return status = 0)
<---

...and I'm sure I've correct syntax and reference! :-?

Thanks for all help!

-bruviken

[bruviken]

Post by bruviken
Hi gurus! I posted this problem at 'administration', but as I didn't get
any response, I thought I shold try here
It seems my syscomments is corrupt due to failure on a disk. However,
fixing the disk and running various dbcc commands will not fix the problem.
--->
Table Corrupt: The row number and offset of each row in the page should
have a matching entry in row number table; check this page (page#=11445
row#=0 offset in row number table=32)
Keys of index id 1 for table 'syscomments' in data page not in correct
order, Drop and re-create the index. (index page 11445)
<---
--->
Server Message: Number 605, Severity 16
An attempt was made to fetch logical page '257' in database 'master'
from cache 'default data cache'. Page belongs to object with id '45',
not to object 'sysdatabases'.
(1 row affected)
(return status = 0)
<---
...and I'm sure I've correct syntax and reference! :-?
Thanks for all help!
-bruviken

Oh, and the OS/ASE is Solaris 7 / ASE 12.5

-bruviken

[Jeffrey R. Garbus]

What did you run to try to fix it?

if dbcc checktable with the "fix" option won't do it, you may need to
contact tech support.

As a last resort (or if tech support is slow), might be possible to copy
all the data into another database, recreate the procs, drop this one.

Jeff

Post by bruviken

Post by bruviken
Hi gurus! I posted this problem at 'administration', but as I didn't get
any response, I thought I shold try here
It seems my syscomments is corrupt due to failure on a disk. However,
fixing the disk and running various dbcc commands will not fix the problem.
--->
Table Corrupt: The row number and offset of each row in the page should
have a matching entry in row number table; check this page (page#=11445
row#=0 offset in row number table=32)
Keys of index id 1 for table 'syscomments' in data page not in correct
order, Drop and re-create the index. (index page 11445)
<---
--->
Server Message: Number 605, Severity 16
An attempt was made to fetch logical page '257' in database 'master'
from cache 'default data cache'. Page belongs to object with id '45',
not to object 'sysdatabases'.
(1 row affected)
(return status = 0)
<---
...and I'm sure I've correct syntax and reference! :-?
Thanks for all help!
-bruviken

Oh, and the OS/ASE is Solaris 7 / ASE 12.5
-bruviken