SAP Knowledge Base Article - Preview

2356768 - Message 1166 on 'alter database' with OFF clause - SAP ASE for BS


  • 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.



  • 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


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


"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.