sybase 926问题 求救
00:00000:00001:2005/12/15 09:44:01.28 serverError: 926, Severity: 14, State: 100:00000:00001:2005/12/15 09:44:01.28 serverDatabase '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 serverError: 926, Severity: 14, State: 1
00:00000:00001:2005/12/15 09:44:13.02 serverDatabase '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 serverUnable 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指教呀熬夜通宵呢谢谢跪求！ 问题是否解决，贴出日志，什么操作系统，SYBASE版本 你的update根本没有成功啊！ 你现在数据库的status位是多少? 问题已经解决，数据库的状态已经改变，主要解决办法是先把status=0 更新，然后将status=-32768 继续更新，谢谢DX的帮助！:em02: 能不能详细点，成功分享 00:00000:00001:2005/12/15 09:44:01.28 serverDatabase '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? haha...
careful about using 'copy', usually congratulate 能够更详细一点吗？
页:
[1]
2