SAP Knowledge Base Article - Preview

2739619 - Error 5055 when shrinking logsegments of a database - SAP ASE


When performing an 'alter database log off' command, the following message is reported and the shrink operation fails:

1> alter database <DBNAME> log off <DeviceName>
2> go
Msg 5055, Level 16, State 1:
Server '<Servername>', Line 1:
You cannot remove %d log pages (%d MB) from the database '%.*s' because the amount of free log space remaining (%d pages, %d MB) would fall below last chance threshold (%d pages, %d MB).



SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0


last-chance, threshold, disk, resize, increase , KBA , 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.