how to schedule offline backup for SAPDB or maxdb

[Former Member]

Hello,

I have stand alone SAPDB server ( without SAp system) , I wanted to know how to schedule the OFFline backup for SAPDB.

Can yo tell me the command to schedule the offline backup .

Command should do like:

1) bring the DB to admin mode.

2) start offline backup .

3) bring the db up after backup done

Regards,

[Former Member]

I have found its solution my own

[Former Member]

HI Bhavesh Abhyankar ,

Could you please share your solution with me. actually i want to do the same in my landscape.

Thanks in Advance.

Viswanathan G

[Former Member]

can you please help me in scheduling offline backup of maxdb in SAP R/3 envirnment.

[adrian_dorn]

If you have a SAP system you could use transaction DB59 and DBACOCKPIT in that system to monitor your stand alone MaxDB. You also could shedule recurrent jobs such as a backup, update statistics, etc. This is certainly more confortable than issuing manually DBMCLI commands on OS level.

Note:

- If the SAP system runs under Oracle, DB2 or MSSQL, then you will need to install some software on the application server to support the communication with a stand alone MaxDB.

- If the SAP system runs under MaxDB, then no software installation is required to communicate with the stand alone MaxDB.

[Former Member]

Hello,

This issue is resolved , I have created 3 task at OS level.

Thanks

[markus_doehr2]

Did you read the available documentation?

> 1) bring the DB to admin mode.

dbmcli -u control,<password> -d <database> db_admin

> 2) start offline backup .

dbmcli -u control,<password> -d <database> backup_start <medium>

> 3) bring the db up after backup done

dbmcli -u control,<password> -d <database> db_online

Basically you can do the same when the database is online, all backups are consistent, there's no difference in "offline" or "online" backup as with other databases (e. g. Oracle).

Markus