sybase 926问题 求救

背景离乡

00:00000:00001:2005/12/15 09:44:01.28 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2005/12/15 09:44:01.28 server  Database 'cwbase3' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.

00:00000:00001:2005/12/15 09:44:13.02 server  Error: 926, Severity: 14, State: 1
00:00000:00001:2005/12/15 09:44:13.02 server  Database 'cwbase6' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.
00:00000:00001:2005/12/15 09:44:13.70 server  Unable to proceed with the recovery of dbid <10> because of previous errors.  Continuing with the next database.

数据库出现926 问题，按照官方的恢复办法：Q.如何解决数据库被标记为"suspect"的问题之一（ 一般解决方案）？  

A.现象：Error 926  
　Severity Level 14  
　Error Message Text  
　Database 'xx' cannot be opened - it has been marked SUSPECT by recover Explanation  

   

(1) 启动Backup Server, 后备master数据库

1>dump database master to "/usr/sybase/master_dump.20051219"
2>go

(2) 用isql登录到SQL Server, 须用sa帐号

1>sp_configure "allow updates", 1  
2>go  
1>begin tran  
2>go  
1>update master..sysdatabases  
2>set status = -32768  
3>Where name="pubs2"  
4>go
(0 row)

1>rollback
2>go

重起数据库，看sybase.log文件仍然报926的错误， 但是在shutdown 前checkpiont   没有报任何错误，
无法执行，请DX指点，小弟非常感谢！

背景离乡

请dx指教呀  熬夜通宵呢  谢谢  跪求！

c001100c

问题是否解决，贴出日志，什么操作系统，SYBASE版本

冷月无声

你的update根本没有成功啊！ 你现在数据库的status位是多少?

背景离乡

问题已经解决，数据库的状态已经改变，主要解决办法是先把status=0 更新，然后将status=-32768 继续更新，谢谢DX的帮助！

clytcn

能不能详细点，成功分享

1017of

00:00000:00001:2005/12/15 09:44:01.28 server  Database 'cwbase3' cannot be opened.

1>update master..sysdatabases  
2>set status = -32768  
3>Where name="pubs2"  
4>go

I have no idea of the relation between cwbase3 and pubs2,there is something wrong happens in pubs2?

YtBenjamin

haha...
careful about using 'copy', usually

jtyhyl

congratulate

showzhonghua

能够更详细一点吗？