From: Eirikur Sveinn Hrafnsson [mailto:[EMAIL PROTECTED]]
> By a mistake a database with two user spaces and lots of data was > dropped and a new one with same name created! > All I have of the original database which is on a linux server are 25 > autosave files. When probing these files with a text editor I can see > lots of data in them from both of these user spaces! The autosave files include the changes of your database written to the log. They do not include the content of your database when autosave starts. > I have tried to restore them using restore from medium etc. but run > into numerous problem. > 1. tried to create new database with the same name on windows 2000. > Found out that sapdb can't be restored from linux > to nt : ( Yes, backups are not independent from the os. > 2. tried restoring to a new database on linux with a different > name but got the error "failed: backup from another database" > or something like that. Start a recovery immediately after the "init config" step (without db_warm) with restoring a full data save. > 3. dropped the database that overwrote the original one and created a new one > with the same name and tried again. This time I get "can't open devspace > please correct and try again" This looks like another problem. Check the knldiag file for more infomation. Summary: With autosaves only you can not restore a totally destroyed database. You will need at least one full data backup and a series of autosaves matching to the data backup. Bernd -- SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
