Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
About "BYPASS RECOVERY" mode
315 views
Skip to first unread message
winton_luo
Jun 28, 2001, 10:09:33 PM6/28/01
to
hello,,but my database had not been shut down before my server had been
restart,and now i can not create or delete table,the information is
"Attempt to BEGIN TRANsaction in database 'gdportrent' failed because
database is in BYPASS RECOVERY mode."
Please tell me what to do,thank you very much!
restart,and now i can not create or delete table,the information is
"Attempt to BEGIN TRANsaction in database 'gdportrent' failed because
database is in BYPASS RECOVERY mode."
Please tell me what to do,thank you very much!
Ivan Santhumayor
Jun 29, 2001, 2:03:24 AM6/29/01
to
You need to reset the bypass recover mode (which is
master..sysdatabases.status==-32768).
master..sysdatabases.status==-32768).
update master..sysdatabases set status=0 where name=<dbname>
winton_luo
Jun 28, 2001, 11:53:34 PM6/28/01
to
Thanks a lot! I get it!
0 new messages