Symptom
- When an asynchronous database allocation is running
- A subsequent 'alter database off' or 'alter database log off' command
- Fails with message 1166 :
Msg 1166, Level 18, State 1:
Server 'SID'
You cannot execute the command 'ALTER DATABASE LOG OFF' on database 'my_db' because it was created with asynchronous initialization and it has not been fully initialized.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
"shrink database" , "shrink db" , "alter off" , "log off" , 1166 , "error 1166" , "message 1166" , "msg 1166", "CRDB AUINIT" , background , async_init , "enable async database init" , "ALTER DATABASE LOG OFF" , "ALTER DATABASE OFF" , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.