How to Schedule Backups in DBAcockpit of SAP Sybase DB + screen shots

By | December 7, 2016

For each and every company where they are software_company or Hardware_company having lot of data. They will process the that data through different tools like Oracle or Sybase-DBAcockpit or Ms-sql or Hana or DB6 etc. And we do not know when they will crash or may attach virus as a accidentally. So every one should maintain the Backups for safety. If anything happened unfortunately, we can restore the data with that backups.

Here, I will teach you, how to take a backups for both full DB and Transaction backups in sybase database through DBA-cockpit as follows.

Procedure for Schedule Backups in Sybase :

  • First of all login into server through SAP logon pad in a local network. Then run transaction code as “dbacockpit” in the transaction-field.
  • ***Make sure, The DBACOCKPIT is configured in your server system.
  • Then go to DATABASE field.
  • As per configuration, schedule it where in transaction level or in web base level.
  • If it is WEB based, there is a small issue. Some time it happened because I faced that issue. That is, when you click on “start in web browser” button. It can not be open in some cases. But it will show the message as “External Browser started. Please wait…”
  • For that you need to do, open the normal Internet explorer before start it. Then open the DBA-cockpit browser. Then it will work fine.
  • Now go to Job of DBA planing calendar. There are two ways you can schedule it. One is you can do it by selecting the dated in planing calendar and anther one is a option like “Schedule Anin Action”.
  • After selecting the option, A new window appear like as below.
    dbacockpit
  • In first step it will show you, what steps you can performs. Then click on “Continue” button. I will goes to job selection field.
    dbacockpit
  • Here, we need to select Action as “SQL script” and schedule-time as start immediately or at particular time or as Recurring Action. It means, we can schedule it as Daily or Weekly or Monthly with the specific time.
  • If you select Recurring action then the recurring enable in the process.
  • Now click on continue button, it will move to Parameters field. In that we need to provide SQL-Script like as below.
    backup
  • Here only we need to provide the SQL-Script for both Dump as well as Transaction Backups.
    • Script for Dump :
      • >dump database <SID> to “<path>”
        >go
    • Script for Transaction :
      • >dump transaction <SID> to “<path>”
        >go
  • Then click on continue, it will moves to Recurrence field. In that we need provide the Dates and time like as below screen shot.
    backups
  • After that click on continue and it will show you entire summary, what you done before.
  • Continue it & finish.

Leave a Reply

Your email address will not be published.