Sybase 926数据库挂起、3414错误解决方案(Error 926 Error 3414)

Sybase 926数据库挂起、3414错误解决方案(Error 926 Error 3414)

Sybase 926数据库挂起、3414错误解决方案(Error: 926 Error: 3414) 4月28日下午解决了Sybase出现的问题，现在整理如下：

一、查看错误日志 errorlog 发现了这段记录

00:00000:00001:2009/04/28 16:13:36.46 server Error: 926, Severity: 14, State: 1

00:00000:00001:2009/04/28 16:13:36.46 server Database 'FD_JXC' cannot be opened. An earlier attempt at recovery marked it 'suspect'. Check the SQL Server errorlog for information as to the cause.

00:00000:00002:2009/04/28 16:13:36.46 kernel network name

200.100.101.100, type ether, port 5000, filter NONE

00:00000:00003:2009/04/28 16:13:36.48 kernel network name yzserver, type ether, port 5000, filter NONE

00:00000:00001:2009/04/28 16:13:36.48 server Unable to proceed with the recovery of dbid <4> because of previous errors. Continuing with the next database.

明显的 926 数据库挂起错误,即先将数据库状态修改为 -32768 然后再修改为 0

/* 1、将 'allow updates' 从 0 改为 1 允许修改系统表*/

sp_configure "allow updates", 1

/* 2、将数据库状态修改为 -32768 即 bypass recovery */

update sysdatabases set status = -32768 Where name="FD_JXC" 这时需要停止Sybase服务并且重新启动Sybase

/* 3、将数据库状态修改为正常 status=0 */

update sysdatabases set status=0 where name="FD_JXC"

sp_configure "allow updates", 0

第二次停止Sybase服务并且重新启动Sybase

这步完成后一般重新设置数据库选项(例如"select into","trunc log on chkpt"等)