数据库926坏掉了,请各位大侠分析下

qjhadm

00:00000:00001:2011/04/11 09:43:48.79 server  Recovering database 'general'.
00:00000:00001:2011/04/11 09:43:48.79 server  Started estimating recovery log boundaries for database 'general'.
00:00000:00001:2011/04/11 09:43:48.82 server  Error: 624, Severity: 21, State: 1
00:00000:00001:2011/04/11 09:43:48.82 server  Adaptive Server failed to retrieve a row via its RID in database 'general' because the requested RID has a higher number than the last RID on the page. Rid pageid = 0x493f3; row num = 0x16. Page pointer = 0x22ADE000, pageno = 300019, status = 0x1, objectid = 8, indexid = 0, level = 0.
00:00000:00001:2011/04/11 09:43:48.84 server  Error: 3414, Severity: 21, State: 1
00:00000:00001:2011/04/11 09:43:48.84 server  Database 'general' (dbid 5): Recovery failed. Check the SQL Server errorlog for further information as to the cause.
00:00000:00001:2011/04/11 09:43:48.84 server  Recovering database 'roles'.
00:00000:00001:2011/04/11 09:43:48.84 server  Started estimating recovery log boundaries for database 'roles'.

wfcjz

Adaptive Server failed to retrieve a row via its RID in database 'general' because the requested RID has a higher number than the last RID on the page. Rid pageid = 0x493f3; row num = 0x16. Page pointer = 0x22ADE000, pageno = 300019, status = 0x1, objectid = 8, indexid = 0, level = 0.

dbcc rebuild_log

andkylee

将数据库状态设置成-32768
然后重建日志 dbcc rebuild_log

qjhadm

会不会不成功?因为有N个库共用了一个设备及日志文件,新手搞的,,我想做,但还没敢,因为是生产系统

Eisen

"N个库共用了一个设备及日志文件"
也许你说的是一个log device，不过dbcc rebuildlog的是那一个库里的segment，和设备上其他库没有关系

qjhadm

明白,多谢

wfcjz

回复 5# Eisen


   你的签名被人用了，还结结实实的就在你楼下。你也不探头看下！

Eisen

不好意思——那个签名也是n年前我从某前辈那里借用来的……