Anyone have MaxDB scripts for database SNAPSHOT creation?

Question

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 · Answer

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 · Answer

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

Host Systems

Anyone have MaxDB scripts for database SNAPSHOT creation?

Was this post helpful?