Announcement Banner
UNSOLVED

zonie1

updated

19 years ago

Z

zonie1

41 Posts

0

1148

March 26th, 2008 12:00

Anyone have MaxDB scripts for database SNAPSHOT creation?

I am integrating MaxDB into our SQL clone backup scripts. We currently use symioctl.exe to snapshot SQL prior to clone activations. MaxDB has a similar snapshot functionality using DBMCLI.exe with a few commands. Anyone have any CMD or BAT scripts to execute the MaxDB snapshot?
  • xe2sdc

    6 Operator

    •

    2831 Posts

    535

    0

    Posted March 26th, 2008 17:00

    Unfortunatly I don't have such scripts .. however considere that while "symioctl" will take care of everything, from the DB to the storage, you have simply to develope a script that will issue first commands against the DB and put it into "hot backup mode" or something like that.. then you have to flush the filesystem (I'm not a Windows expert, on unix we have the "sync" command). Now you can snap the DB using either symsnap or symclone. When the snap (or the clone) is active you can turn the DB to its usual behaviour (disable the "hot backup mode").
  • zonie1

    41 Posts

    535

    0

    Posted May 16th, 2008 10:00

    Unfortunately, symioctl does not support MaxDB

    I did find a good site and eventually found the "Logwriter" commands to script the backups along with my SQL and Oracle scripts.

    MaxDB Site
    https://www.sdn.sap.com/irj/sdn/maxdb