showserver,查到sybase的pid
kill pid关闭sybase,或者登录到isql上shutdown(推荐后者)
从$SYBASE/$SYBASE_ASE/install/下的RUN_[servername].sh脚本启动sybase
解决:1、重启数据库,重启日志停在“database has not been recovered yet,please wait and try again”2、
1>sp_configure "allow updates", 1
2>go
1>begin tran
2>go
1>use master
2>go
1>update sysdatabases
2>set status = -32768
3>Where name="pubs2"
4>go
如果得到(1 row affected),则
1>commit
2>go
否则
1>rollback
2>go
1>shutdown with nowait
2>go
重启数据库
1>dump tran dbname with no_log
2>go
1>update sysdatabases set status=0 where name=dbname
2>go
重启数据库 转载,仅供参考。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)