SAPDB : Archive the Log and Data files

[Former Member]

Hi,

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.

Regards,

Shubham

[roland_mallmann · Accepted solution]

Hi,

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,

Roland