How to schedule a periodic backup policy on SAPDB

[Former Member]

Dear all,

We have a Content Server running on SAPDB 7.4.

We are wondering about NO posibility to schedule a daily backup policy from SAPDB Database Manager.

We have checked some documentation and we have seen that on a SAP system runnig over SAPDB/MAXDB it is possible to use CCMS (DB13) in order to do it so.

But this is not the case since we Content Server does not have CCMS (DB13).

We just would like to know how we can do a total copy with checkpoint everyday and schedule it on system in order to avoid a daily manual operation.

Could someone give us a little of light on this subject

Best regards

[Former Member]

Dear all,

Thank you very much for all your answers and quickness.

For now I will schedule a .bat script with dbmcli command.

For sure I will revise to migrate MAXDB 7.6 and also the possibility to use CCMS following your recomendations.

Again thanks to all

[lbreddemann]

Hi Xavier,

first of all, SAP DB 7.4 is not supported any longer for several years now.

It's highly recommended to upgrade to MaxDB 7.6.

Concerning your original question: why don't you use the DB13C transaction?

There you can also integrate DB Servers that don't have a ABAP stack running on - e.g. a ContentServer.

All you've to do is to first integrate the ContentServer in transaction DB59.

After that start transaction DB13C -> "Configuration" -> "Add System" and configure a "Non-SAP Web AS System" with DB-Type "SAP DB/ANY". Enter the database server hostname and the name of the DB connection you created in DB59.

That's it!

Having done that you can schedule the most important DBA maintenance jobs (backups, optimizer stats, verify) and you can use transaction DB50 as well as the RZ20 CCMS monitoring to keep an eye (if you want to) on your ContentServer database.

Best regards,

Lars

p.s.

It's nothing to say against scheduling the backups externally, but if you do so, please make sure that you use the XUSER feature instead of specifying the password of your control user in the dbmcli-call.

[former_member229109]

Hello Xavier, Hello Lars,

It's possible for Xavier to monitor the database on the Solution Manager system, for example.

1) Before to integrate the database in /ndb59:

A) check if the database client software installed on the application server.

See SAP notes:

822239 FAQ: MaxDB Interfaces

649814 Updating MaxDB/ liveCache client software

B) What is the SAP Basis SP on the Solution Manager system & what is the SAP kernel version the Solution Manager system?

-> If the system is NOT running with MAXDB, the MAXDB database-dependent part of the SAP kernel need to be installed, which is known as the DBSL installed on the application server.

SAP notes :

325402 dbadaslib/dbsdbslib: How do I apply a patch?

822239 FAQ: MaxDB Interfaces

After that the application server need to be restarted.

2) Now you could integrate the database in /ndb59.

See in the SAP note 588515 the section 3.

Call transaction DB59, Select "Integrate database" & create the database

connection, for example, TEST < You could name it MAXDB_<SID> to have

unique connection name>. And follow the further instructions.

Please run the 'Connection test' after that & review the log.

After the database connection was created in /ndb59 you could double click

on the created connection TEST .

Or /ndb59 -> select connection -> click database assistant bottom =>

it brings you to the database assistant (DB50/DB50N).

-> As I already wrote above, please review the SAP note:

431508 SAP WebAS - using DB13C or DB13 for SAP DB systems

< DB13 and DB13C (up to 6.40): Central DBA Planning Calendar

DBACOCKPIT: Start DBA Cockpit (as of SAP Release 7.0) >

-> Please review the SAP note::

990602 FAQ: CCMS for MaxDB/SAP liveCache technology

-> For SAP documentation see the SAP note 767598.

For SAP MaxDB documentation in English go at:

http://help.sap.com/saphelp_nw04/helpdata/en/07/595f51b1889b478869e338198171b5/frameset.htm

< -> Database Administration in CCMS: MySQL MaxDB -> Central DBA Planning Calendar ! >

Thank you and best regards, Natalia Khlopina

[former_member229109]

Hello Xavier,

-> Please review the SAP note:

431508 SAP WebAS - using DB13C or DB13 for SAP DB systems

-> If you are using an SAP product with SAP WebAS Basis 6.10 or higher,

you could follow the SAP note 431508 to manage DBA actions in TA db13 or db13c

for your database of the Content Server.

As SAP customer, you could run the database administration and monitoring of the

MaxDB instances using your Solution Manager system.

-> Please review the discussion at the thread

-> You will find information for versions 7.3 and higher in the SAP online documentation:

"Backups (with the Database Manager GUI)": http://help.sap.com/saphelp_nw04/helpdata/en/bd/1ef76857c511d4aa83006094b92fad/frameset.htm

"Backups (with the Database Manager CLI)":

http://help.sap.com/saphelp_nw04/helpdata/en/f6/f856d2469c11d4aa1100a0c9430730/frameset.htm

&&

"Backups & Recovery" and "Database Administration in CCMS: MaxDB" http://maxdb.sap.com/currentdoc/default.htm

Thank you and best regards, Natalia Khlopina

[markus_doehr2]

It depends on the operating system you use and the backup software.

It's not difficult to write a one-liner script like (for Windows)

dbmcli -u <controluser>,<controlpassword> -d <SID> backup_start <medium> <backuptype>

and use the Windows "Task Scheduler" to schedule that.

The same is true for Unix systems - you can use a cron entry here.

AFAIK no database has such a function by default, for Oracle you need Enterprise Manager (which is neither officially supported nor included in the SAP license).

--

Markus

[former_member204746]

schedule a task in your OS that calls a script such as this one:

dbmcli -u control,control medium_put completeF X:\backup.LCA FILE DATA 0 8 YES

dbmcli -d LCA -u control,control -uUTL -c backup_start completeF