SAP Knowledge Base Article - Preview

2359499 - Message 5072 'cannot remove first 256 pages' when running alter database OFF - ASE


  • Running command 'alter database off' to shrink a database
  • Returns message 5072 : 
Msg 5072, Level 16, State 1:
Server 'SID', Line 1:
ALTER DATABASE cannot remove the first 256 pages of a database.



SAP Adaptive Server Enterprise (ASE). Not version specific.


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


"shrink database" , "shrink db" , "alter off" , 5702 , "error 5702" , "message 5702" , "msg 5702", "alter database off" , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

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