SAP Knowledge Base Article - Preview

2824596 - How to bring a DB online after performing a dbcc dbreboot('shutdown_load')? - SAP ASE

Symptom

How to bring a DB online after performing a dbcc dbreboot('shutdown_load')?

1> dbcc dbreboot(shutdown_load,test_db)
2> go
---------- Shutting Down Database 'test_db' ----------
---------- Operation on Database 'test_db' Completed Successfully ----------



1> dbcc dbreboot(reboot, test_db)
2> go
---------- Shutting Down Database 'test_db' ----------
---------- Re-starting Database 'test_bs' With Recovery ----------
Msg 930, Level 14, State 1:
Server 'myserver', Line 1:
Database 'test_db' cannot be opened because either an earlier system termination
left LOAD DATABASE incomplete or the database is created with 'for load' option.
Load the database or contact a user with System Administrator (SA) role.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.