SAP Knowledge Base Article - Preview

2280136 - How to look inside a master database dump without restoring it - SAP ASE


  • How to look at the content of a master database dump without restoring it?
  • You will get a 3109 error if you try to load a master database dump to a user database.

1> load database dummydb from "/dump/master.dmp"
2> go
Backup Server session id is: 10. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: Dumpfile name 'master160350C554 ' section number 1 mounted on disk file '/dump/master.dmp'
Msg 3109, Level 16, State 1:
Server 'ASETEST', Line 1:
This dump was created from the Master database. A dump from Master can only be loaded as part of the Restore Master procedure.



  • SAP Adaptive Server Enterprise (ASE) 15.x
  • SAP Adaptive Server Enterprise (ASE) 16.0


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; Sybase Adaptive Server Enterprise 15.0 ; Sybase Adaptive Server Enterprise 15.5


archive, archivedb, scratch, scratchdb , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.