（更新解决方法）Error: 2628, Severity: 21, State: 3错误解决，请大侠们帮帮忙

zdz000

日记记录如下：
112:00000:00009:2010/12/09 09:10:28.58 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:28.58 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:32.22 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:32.22 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:36.44 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:36.44 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:40.39 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:40.39 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:44.48 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:44.48 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:48.44 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:48.44 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:53.08 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:53.08 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:10:57.41 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:10:57.41 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:01.44 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:01.44 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:05.74 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:05.74 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:09.76 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:09.76 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:13.82 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:13.82 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:17.61 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:17.61 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:21.59 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:21.59 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:33.65 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:33.65 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.
112:00000:00009:2010/12/09 09:11:38.76 server  Error: 2628, Severity: 21, State: 3
112:00000:00009:2010/12/09 09:11:38.76 server  In database 'rnosdb', page 60042467 is linked forward to page 60309379, but that page is linked backward to page 60309334. Please report this internal error to Sybase Technical Support.

一直提示这个错误，也不提示是哪个表的索引坏了，请问这个怎么查啊？

andkylee

dbcc traceon(3604)
go
dbcc page("rnosdb",60042467,2)
go
会知道此页60042467 是数据还是索引，以及索引的indid。

andkylee

页：60042467  是indid=2的非聚簇索引的叶子级别的页面。
可以重建该非聚簇索引。

zdz000

回复 4# andkylee


    感谢您的指导
   我找了很多办法，依然无法查到这个损坏的索引名称，请您再指点一下，怎么能查到这个索引名称啊？

Eisen

dbcc allocdump(4,60042467)看看

zhaopingzi

是怎么解决的,楼猪也不说一下,也太不地道了吧

zdz000

回复 7# zhaopingzi


    这个问题是说有表的页链发生了问题。如果硬件没有问题，可以按一下步骤解决：

1.先确定是哪个表的问题：dbcc traceon(3604),go，然后dbcc page (database_name, page_number)
2.如果是数据页，IndexID=0,就把clustered索引drop掉重建；
3.如果是索引页，indexID>0,就把索引drop掉重建；

做完后，运行一下dbcc linkpage看看是否已经正常。

用法：
dbcc pglinkage (dbid, start_pg_num, number_pages,printopt, search_for, search_order)

dbid - database ID
start_pg_num - page number at which to start checking
number_pages - the number of pages to check:0 - check all pages
printopt - denotes which pages to display:
0 - display only the number of pages checked
1 - display the last 16 pages checked
2 - display all the page numbers checked
search_for - stop checks when this page number is reached

search_order - direction of search:
0 - follow previous page pointers
1 - follow next page pointers

后四项可以是0，1，0，1

zdz000

dbcc traceon(3604)
dbcc pglinkage(dbname,60042467,0,1,0,0)

andkylee

2楼已经告诉方法了。~