SAP Knowledge Base Article - Preview

3094124 - sp_shrink does not recognize when the server is in single user mode - SAP ASE


  • Issues to reduce data from sybsecurity database.
  • Customer is using flat file devices. Data and log are separated
  • Customer wants to know how to free data from their sybsecurity databases.
  • Customer try to run sp_shrink with ASE started in single user(-m) and get error:
    • DBCC: checking database 'sybsecurity'.
      DBCC execution completed. If DBCC printed error messages, contact a user with
      System Administrator (SA) role.
      Msg 17435, Level 16, State 1:
      Server 'xxxx', Procedure 'sp_dboption', Line 849:
      The 'single user' option is not valid for the 'sybsecurity' database.
      (return status = 1)



  • SAP NetWeaver Application Server for ABAP 7.52
  • SAP Adaptive Server Enterprise 16.0 SP03 PL06 and higher.


SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver Application Server for ABAP 7.52


CR825458,825458, sp_shrink,Msg 17435 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.