论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2006-03-19 22:21 |只看该作者 |倒序浏览

执行存储过程时报错:attempt to begin tranasction in database 'aa' failed because database is in bypass recovery mode

将AA的STATUS改为-32768,然后重起服务,清空日志,但还是不行,哪位有办法啊?急!!!

OS:WIN2000
SYBASE:12.5
CPU:2.8

[ 本帖最后由 junqiang0904 于 2006-3-20 19:03 编辑 ]

文库|博客

冷月无声

丰衣足食

论坛徽章:: 0

2楼 [报告]

发表于 2006-03-20 10:50 |只看该作者

select name,status from sysdatabases看看数据库状态

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

zhaopingzi

巨富豪门

论坛徽章:: 71

3楼 [报告]

发表于 2006-03-20 11:27 |只看该作者

你还得将AA的STATUS改为0呀,改回去啊

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

1017of

大富大贵

论坛徽章:: 4

4楼 [报告]

发表于 2006-03-20 11:30 |只看该作者

setting status of your database to -32768 would make it in bypass recover status.the hint of being shown is much clear to tell what happened.you can not begin transaction in your database when it is in bypass status.
to solve this problem,you should set back status to it's original value other than -32768,and restart ASE server.if no further error comes,it should be available.
btw:don't truncate trans in bypass status arbitratily unless you have not other ways.that is too dangerous.