> -----Original Message----- > From: Andreas Grund [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 12. Juni 2003 08:08 > To: Brunzema, Martin > Subject: Re: RE: restoring database from complete data backup > > > "Brunzema, Martin" <[EMAIL PROTECTED]> schrieb am > 12.06.03 00:39:17: > > > > > > > > > -----Original Message----- > > > From: Andreas Grund [mailto:[EMAIL PROTECTED] > > > Sent: Mittwoch, 11. Juni 2003 14:49 > > > To: [EMAIL PROTECTED] > > > Subject: restoring database from complete data backup > > > > > > > > > Hi, > > > > > > i started just a quick test to test the backup from sap db. I > > > installed a new instance "butest" and imported a datatable > > > from MS Access with round about 14.000 lines. Then I made a > > > complete data backup, drop the table with the SQL Studio and > > > started then restoring with the DBM GUI. The program said, > > > that the restore is complete and the database has been > > > restarted. Now I started the SQL Studio to test, if the data > > > table has benn restored, but it isn�t there. I do not find > > > the table. Where is my failure?? Can someone help me?? > > > > > > > Hi, > > > > the drop table is "remembered" in the log-entries on the log > > and therefore it is executed again during the restart in order > > to bring the database in the "youngest" possible state. > > > > see also > http://listserv.sap.com/pipermail/sapdb.general/2003-May/020864.html > > > > regadrs, Martin > > _______________________________________________ > > sapdb.general mailing list > > [EMAIL PROTECTED] > > http://listserv.sap.com/mailman/listinfo/sapdb.general > > Hi, > > so i have to clean the log-entries first, if i want to > restore the database on the level from the last backup, correct? >
You should do a point-in-time recovery by using the -u option of the db_online command. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
