Skip to Content
author's profile photo Former Member
Former Member

SAPDB : Archive the Log and Data files


I am running a SAP WAS JAVA on my laptop with SAPDB as the database. Its used for my local developments.

I have 3 log files and 3 data files of 1 GB each. I want to reduce this to 1 log file and 1 data file to free some space on my Laptop.

How can this be done.



Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Apr 11, 2006 at 12:52 PM


    well, you should check the <b>current filling level</b> of your database instance to see how large your single data volume should become.

    Then, I would recommend you put your db in <b>admin</b> state and make a full data <b>backup</b>.

    Then, you would need to do do a <b>recovery with initialization</b>. This is most conveniently done using the newest available version of the Database Manager GUI.

    During this process, you should be able to specify your desired new volume setup (please keep the filling level from your the beginning in mind). For the backup to recover, choose the one you just made.

    Hope that helps.

    Kind regards,


    Add comment
    10|10000 characters needed characters exceeded