Sybase_926数据库挂起、3414错误解决方法.docxVIP

Sybase 926 数据库挂起、3414 错误解决方法(Error: 926 Error: 3414) 一、查看错误日志 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等) exec sp_dboption FD_JXC, select into/bulkcopy ,true exec sp_dboption FD_JXC, trunc. log on chkpt ,true 运行 dbcc 命令检查数据库的一致性dbcc checkdb(FD_JXC) 备份用户数据库 dump database FD_JXC to D:\backup\FD_JXC0428.dump 晕死，眼看胜利在望，服务器蓝屏,无语，破机器，只好非法关机重新启动，启 动好后数据库还是无法正常使用，再查看错误日志 errorlog ,我的神啊，竟然变成 3414 错误了，肯定是刚才蓝屏的时候，数据库在恢复日志被中断了，这样就要重建数据库日志了 190197: Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.) 00:00000:00001:2009/04/28 16:40:14.75 server Error: 3414, Severity: 21, State: 1 00:00000:00001:2009/04/28 16:40:14.75 server Database FD_JXC (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the cause. Error: 3414, Severity: 21, State: 1 Database FD_JXC (dbid 4): Recovery failed. Check the SQL Server errorlog for further information as to the cause. 解决办法: 重建数据库日志,方法如下: /* 1、赋予 sa 用