??? Uhm... do you mean that I have to create the database from the dbmgui instead of using my creation script? Let's say that I want to take the database instance to a known state of one week ago... in this case I need to destroy it, recreate it using the wizard, and then restore? It seems to me more complicated than necessary... why can't the dbmgui issue a "clear log" statement before restoring a full backup? Best regards Andrea Aime
Heinrich, Tilo wrote:
Hello Andrea,
reinstall your new database with DBMGUI and select in the step "Installation Mode" the option "For Restore", after the Database Wizard finished work, do not restart the database, but recover the backup with DBMGUI.
Best Regards, Tilo Heinrich SAP Labs Berlin
-----Original Message----- From: Andrea Aime [mailto:[EMAIL PROTECTED] Sent: Montag, 10. M�rz 2003 11:10 To: [EMAIL PROTECTED] Subject: DbmGUI, backup and restore
Hi everybody, I'm having problems backing up and restoring a database using only the dbmgui 7.4. I'm using SapDB 7.3. What I did is: * a complete backup, either in warm (+ migrate settings) or cold state (tried both); * moved the backup onto another PC with sapb 7.3 and an empty copy of the database (I just run a modified version of the TST creation script); * did a restore from dbmgui, which went fine, and then restarted the database. After restart, I got the following error: sql_error[db_warm -f]; -8003, Message not available
I've looked at some script files for linux and did some tests, and discovered that if I run the following script, which clears the log, before trying to restore everything goes fine, and after the restart the database is ready to be used...
script:
dbmcli -d <dbname> -u dbm,dbm db_cold util_connect dbm,dbm util_execute clear lor exit
Well, it would be nice not to have to do this step, since it's not me to use the backup/restore system, but one of my clients, that's not a computer expert (the less the steps, the less problematic is the procedure...) Best regards Andrea Aime
_______________________________________________ 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
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
