Hi, after reading multiple SAPDB docs and trying to understand the backup/restore concepts, I tried a little test:
1) created a new table, added 3 records (autolog is on) 2) made full data backup using a script. 3) inserted a 4th record 4) stopped the DB; deleted the data file 5) restored the db using this commands: >dbmcli -d MYDB -u dbm,dbm >db_cold >util_connect dbm,dbm >recover_start data DATA >util_release >db_warm database restored OK, but: I restored a database that contains 4 records, but my data backup only contained 3 records. What happened??? Another issue: the same commands executed in a .bat script don't run. I receive this error: dbmcli on PORTAL>ERR -24992,ERR_NOUTILSESSION: no utility session available Here is the script: @echo off rem ** sapdb bin path ** set PATH=c:\sapdb\indep_prog\bin;c:\sapdb\indep_prog\pgm;%PATH% rem ** name of the database ** set SID=PORTAL rem ** backup database ** echo db_cold echo util_connect dbm,dbm echo recover_start data DATA >> param.tmp echo util_release echo db_warm type param.tmp | dbmcli -d %SID% -u dbm,dbm >> restore_log.txt del param.tmp ----- It would be so great to have 2 sample scripts for these tasks: one for regular full data backups, and another for restore of the data and last transactions, just as the db_create and db_drop sample scripts included in the distribution. Regards, Martin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
