Here is a script. Change dbm password according to your case; save this script to a .bat file (Windows 2000). This is a full data restore (no autologs restore).
There is a document (http://www.sapdb.org/7.4/pdf/backrec_eng.pdf) that explains the backup/restore commands with DBMCLI. It is not a bullet-prof how-to, but is the best you will find. I have lots of problems trying to understand the restore process, and this document has not helped me too much (maybe its me!), many of the commands have not worked in my SAPDB installation. I am almost resigned to restore data backups only, because is the only thing that has worked for me as expected. @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=PROD echo RESTORING DATABASE echo db_cold >> param.tmp echo util_connect dbm,dbm >> param.tmp echo recover_start data DATA >> param.tmp echo util_release >> param.tmp echo db_warm >> param.tmp type param.tmp | dbmcli -uUTL -d %SID% -u dbm,dbm>> restore_log.txt del param.tmp ----- Original Message ----- From: "Matthias Suttner" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 11, 2003 9:15 AM Subject: How can i recover/restor a SAPDB with DBMCLI? > Hi, > > can anybody tell me all commands to recover a database? I don't found > any documentation of all steps. > > I have a complete backup from Server1. > Now i want to recover these backup on Server2. > > With the GUI this is no problem. But I want to do all steps with > DBMCLI. Is this possible? On Server2 only the DBM without any DB is > installed. > > > Thx > > Matthias > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
