2006-7-20 09:45
ayong986
【疑问】BYPASS RECOVERY mode是什么意思?
谢谢~!
$ isql -Usa -Psasasa
1> sp_helpdb
2> go
Msg 3908, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_helpdb', Line 143:
Attempt to BEGIN TRANSACTION in database 'tempdb' failed because database is in
BYPASS RECOVERY mode.
Msg 208, Level 16, State 6:
Server 'SYBASE', Procedure 'sp_helpdb', Line 152:
#spdbdesc not found. Specify owner.objectname or use sp_help to check whether
the object exists (sp_help may produce lots of output).
(return status = -6)
1>
这是什么错误!怎么解决啊,希望大家给指个路~!
2006-7-20 09:46
ayong986
1. Reset the database status to 0:
1> sp_configure "allow updates", 1
2> go
1> begin tran
2> go
1> use master
2> go
1> update sysdatabases set status=0 where name=<database_name>
2> go
Check that the above update command affected only one row (if more than one row was affected, issue a rollback transaction.) Then commit the transaction and shut down Adaptive Server as follows:
1>commit tran
2>go
1>shutdown with nowait
2>go
2. Restart Adaptive Server. Run dbcc checkdb and dbcc checkalloc on the affected database to make sure there are no errors.
Version in Which This Error is Raised
All versions.
这个方法可以不?
现在这个出错误的数据库不在我这,,我是帮别人问问。