Forum Discussion

pitt2017's avatar
pitt2017
Level 3
11 years ago

Backing up Opscenter SQL Anywhere DB via Sybase script

Can someone please verify wheather or not it is possible or supported to use the sample \Veritas\NetBackup\DbExt\sybase\sybase_full_backup.cmd script to perform a policy based backup of the OpsCenter DB?
 I want to obtain a backup via a NB policy instead of just dumping the files locally.

When i fill in the proper fields I recieve the following undocumented error below:


Error bpbrm (pid=6042) from client nb-ops: <"C:\Program Files\Veritas\NetBackup\DbExt\sybase\sybase_full_backup.cmd"> failed with status: <9009>
Error bpbrm (pid=6042) from client nb-ops: ERR - bphdb exit status = 6: the backup failed to back up the requested files
03/21/2014 10:26:32 - Info bphdb (pid=7312) done. status: 6: the backup failed to back up the requested files
03/21/2014 10:26:32 - end writing

I am aware there is a DBBACKUP batch script that backs this database up locally, but this is not what I am looking for as a solution. Any help would be appreciated. Thank you.

7.6
Agents
Backing Up
Backup and Recovery
Basics
NetBackup
Troubleshooting
Windows Server (2003-2008)
  • Mark_Solutions's avatar
    Mark_Solutions
    11 years ago

    I think if it would work that way Symantec would reccomend it and provide the process to do it .. but they do not and their method of protection is to do the dumps http://www.symantec.com/docs/TECH129948

    You could incorporate this into the OpsCenter servers backup running the commands in a bpstart_notify.bat file so that the dump is captured during the backup

    Best stick to a supported method

4 Replies

Sort By
  • Mark_Solutions's avatar
    Mark_Solutions
    Level 6
    11 years ago

    I think if it would work that way Symantec would reccomend it and provide the process to do it .. but they do not and their method of protection is to do the dumps http://www.symantec.com/docs/TECH129948

    You could incorporate this into the OpsCenter servers backup running the commands in a bpstart_notify.bat file so that the dump is captured during the backup

    Best stick to a supported method

  • pitt2017's avatar
    pitt2017
    Level 3
    11 years ago

    Thank you Mark for your suggestions.

    I ask this only because it seems logical that this would somehow be supported seeing as the OpsCenter DB runs under Sybase and NetBackup has a Sybase specific backup policy / script to handle Sybase backups.

    Is there anything that you could think of that would cause the Opscenter DB to not be supported under a normal Sybase backup policy?

  • Mark_Solutions's avatar
    Mark_Solutions
    Level 6
    11 years ago

    What did you use for the username and password (I believe it is DBA and SQL)

    It may be the type of database as it is the Stbase Server Anywhere - so maybe it uses different command sets.

  • Will_Restore's avatar
    Will_Restore
    Level 6
    11 years ago

    Adaptive Server Anywhere and Third-Party Backup

    iAnywhere Solutions, at time of writing, does not endorse any third-party backup software to be used with an Adaptive Server Anywhere database. Only backup tools included with Adaptive Server Anywhere can be used to back up a live database. You should be aware there are some products that claim they back up Sybase databases, but this may not include Adaptive Server Anywhere databases.

     

    for more info, see http://www.sybase.com/detail?id=1025501