Uwe (and anyone else who can help), I foolishly assumed that because I got OK on all steps and ONLINE status.. that the data was there. However, this weekend I sat down to do some work with the data and it is missing! None of my tables are actually restored, and 'info state' shows only 2MB of consumed pages where the backup source datbase and backup file is 9GB!
This is from MaxDB 7.5.0.5 to 7.5.0.5 on Windows 2000 to Windows XP Professional. Can you review my restoration steps again and see if there is some error? dbmcli -n localhost -d MYDB1 -u DBM,** medium_put completeF c:\MaxDB-servermy1-bk000.data FILE DATA 0 8 YES dbmcli -n localhost -d MYDB1 -u DBM,** -uUTL -c backup_start completeF MIGRATION Script I am using for restore: http://www.ipcoast.com/MaxDB-Restore02.txt I am ONLY using the data file, I am not concerned with the LOG files. I just need a snapshot. Thankfully we left one of our systems at 7.4.3.027 and are replicating our INSERT/UPDATE statements. I am not having problems with 7.4.3.027 to 7.4.3.027 backup and restore. Stephen Gutknecht -----Original Message----- From: Hahn, Uwe [mailto:[EMAIL PROTECTED] Sent: Thursday, December 04, 2003 12:44 AM To: 'Stephen Gutknecht (SAPDB)'; [EMAIL PROTECTED] Subject: AW: MaxDB 7.5.0.5 Restore problems - log file not created I have included a few changes. Uwe [...] rem ########################################################## rem ### startup database rem ########################################################## dbmcli -d %SID% -u %uDBM%,%uDBMPW% db_admin echo . echo *** echo *** Just completed db_admin echo *** :Skip1 echo *** echo *** Next step is to start restore! echo *** pause echo medium_put completeFile %restoreFile% FILE DATA 0 8 YES >> param.tmp echo util_connect > param.tmp echo db_activate recover completeFile >> param.tmp echo db_online >> param.tmp type param.tmp | dbmcli -d %SID% -u %uDBM%,%uDBMPW% echo *** echo *** Did the database go warm? Next step is to load system tables. echo *** pause rem look at the state - is it ONLINE ? dbmcli -d %SID% -u %uDBM%,%uDBMPW% db_state rem load database system tables dbmcli -d %SID% -u %uDBM%,%uDBMPW% load_systab -u %uDBA%,%uDBAPW% -ud domain [...] -----Urspr�ngliche Nachricht----- Von: Stephen Gutknecht (SAPDB) [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 4. Dezember 2003 09:01 An: Hahn, Uwe; [EMAIL PROTECTED] Betreff: RE: MaxDB 7.5.0.5 Restore problems - log file not created Hello Uwe, I tried doing it in several places, not making progress. Getting various errors. Including the following when I put it after db_start: dbmcli on TEST4>ERR -24988,ERR_SQL: sql error -101,Message not available Can you pretty please review my script and tell me where to insert db_activate with RECOVER option? http://www.IPCoast.com/MaxDB-Restore01.txt Any other things you notice missing / incorrect in my script? I seem to have the worst luck with syntax changes to the restore process. Thank you. Stephen Gutknecht -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
