My database is in bypass recovery mode. How do I put it in...

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

<< Back to: Sybase FAQ: 9/19 - ASE Admin (6 of 7)

[ Home | FAQ-Related Q&As | General Q&As | Answered Questions ]

Question by Lach
Submitted on 9/1/2003
Related FAQ: Sybase FAQ: 9/19 - ASE Admin (6 of 7)
Rating:	Rate this question:
My database is in bypass recovery mode. How do I put it in normal mode?

Answer by Thorofin
Submitted on 6/10/2004
Rating:	Rate this answer:
First, change options to allow update of system tables. 1> sp_configure "allow updates", "true" 2> go Change the status of the database to 0, the reboot the database server. 1> begin tran \In case it goes awry\ 2> go 1> update sysdatabases set status = 0 2> where name = "<DB NAME>" 3> go If only one row is affected, proceed, otherwise rollback the transaction 1> commit tran 2> go 1> shutdown 2> go When the server restarts it will try to recover the database. Don't forget to set the option to allow updates back to "false" when you are done.

Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer: