From: marele [mailto:admin@;salda.lt]
> I need to migrate data from one instance to another (no > matter on another > computer or on the same). > > I create complete backup ( for migration). Then I create a > database - tryed > different combinations: copy parameters from backup, > copy parameters from backup, create new database with the > same parameters > and then restore database from backup. > In all cases I got an error 8003 - The log and data area must > be compatible. > If I make a log bakup and then try to restore log > it causes the same error. > What's wrong with my database or log? > I use SAPDB 7.3.0.29 and Darabase Manager 7.4 on WinXP Do not bring the new database in operational mode ONLINE (formerly called WARM) before the restore. In the database installation wizard of the DBMGui choose the "Restore instance" radio button at the page before last. At the command line skip the installation after the "INIT CONFIG" step. Now you have a database in the operational mode ADMIN (formerly called COLD) and you can execute the restore with your complete backup. Explanation: During the restore only the data volumes are written. The log volumes hold still the log entries from the time the dabase was ONLINE. This log does not match to the data from the restore. Bernd -- SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
