SAP Knowledge Base Article - Preview

2527545 - Error 5053 or 5056 when shrinking logsegments of a database - SAP ASE

Symptom

When executing command the following command to shrink the log part of a database

alter database ... log off ...

it fails with one of the following error:

error 5056: You cannot remove %d pages (%d MB) from database '%.*s'; only %d unreserved pages (%d MB) are available.
error 5053: You cannot shrink the log in database '%.*s' because there is at least one page to be removed (%d) that is part of the log. Dump the transaction log and retry the ALTER DATABASE command.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

shrink, alter database, log off, 5053, 5056, shrinking, logsegment , 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 ONE Support launchpad (Login required).

Search for additional results

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