Error: 625,dbcc rebuild_log也不行，求解

kanfu

00:00000:00001:2014/03/08 19:39:06.70 server  Error: 625, Severity: 21, State: 1
00:00000:00001:2014/03/08 19:39:06.70 server  Adaptive Server failed to retrieve a row via its RID in database 'RPT' because the entry in the offset table for that RID is less than or equal to 0. Rid pageid = 0x2d80f5; row num = 0x1a. Page pointer = 0x5307D000, pageno = 2982133, status = 0x1, objectid = 8, indexid = 0, level = 0.
00:00000:00001:2014/03/08 19:39:06.70 server  Error: 3414, Severity: 21, State: 1

kanfu

数据库版本：Adaptive Server Enterprise/12.5.4/EBF 14346 ESD#5/P/NT (IX86)/OS 4.0/ase1254/2061/32-bit/OPT/Thu Apr 12 21:34:18 2007

kanfu

把Status改成-32768后重启，提示数据库offline

kanfu

1> online database RPT
2> go
Msg 834, Level 20, State 4:
Server 'rptserver', Line 1:
Illegal attempt to clean buffer: BUF=0x67618F90, MASS=0x67618F90, Buf#=0,
page=0x60E5D000, dbid=4, Mass vpage=101597429, Buf lpage=2982133, Mass
stat=0x44201008, Buf stat=0x1, size=2048, cid=0 ('default data cache'), Pinned
xdes=0x00000000, spid=0.
SQL Server could not bring database 'RPT' online.

hobbylu

这个还是syslogs日志出的问题，有没有有效备份？

jp_1129

SYBASE3414错误处理:
解决办法:
重建数据库日志,方法如下:
　(1)赋予sa用户sybase_ts_role的角色
isql -Usa -P
1>sp_role "grant","sybase_ts_role",sa
2>go
1>quit

(2)将数据库置为"bypass recovery"状态
isql -Usa -P
1>sp_configure "allow updates",1
2>go
1>use master
2>go
1>update sysdatabases set status=-32768
2>where name="database_name"
3>go
1>shutdown with nowait
2>go
(3)rebuild数据库日志
重启Server
isql -Usa -P
1>use master
2>go
1>dbcc rebuild_log(database_name,1,1)
2>go
1>shutdown with nowait
2>go
(4)重启server
1>use master
2>go
1>update sysdatabases set status=0 where name="database_name"
2>go
1>sp_configure "allow updates",0
2>go
1>shutdown with nowait
2>go
(5)在重启server之后,如果数据库恢复正常，rebuild log工作将会成功完成，否则要恢复数据库备份，使用dump database或bcp命令。

参见：http://blog.chinaunix.net/uid-7509663-id-25471.html

good luck!