Hi Ralf, the error text of -2008 is Devspace size too small. You have to increase the capacity of your data area (=> more data volumes). You have to insure that the target size in pages is larger than the maximum of "MaxUsed Data Page" and the "Page Count" of the backup file. (only 7.3, in 7.4 is much better!)
Both values could be find out by the following sequence 1) dbmcli -d <TARGET_DATABASE> -u ... db_cold 2) dbmcli -d ... -u ... medium_label <MEDIUM_NAME_OF_BACKUP_FILE> Output looks like: OK Returncode 0 Date 20030226 Time 00122847 Server p46813 Database SUT73 Kernel Version Kernel 7.3.0 Build 033-000- Pages Transferred Pages Left Volumes Medianame Location xinitdb.sav Errortext Label DAT_00001 Is Consistent true First LOG Page 19 Last LOG Page DB Stamp 1 Date 20030226 DB Stamp 1 Time 00122846 DB Stamp 2 Date DB Stamp 2 Time Page Count 22 <==================================================== Devices Used 1 Database ID p46813:SUT73_20030226_122841 Max Used Data Page 29 <==================================================== Note that you nead about 15 - 20 percent free space in the data area to avoid trouble with db_full situations, ... Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message----- From: Henneke Ralf [mailto:[EMAIL PROTECTED] Sent: Mittwoch, 26. Februar 2003 11:56 To: [EMAIL PROTECTED] Subject: Error -24988 during restore database => with description -2008 Hi, I�ve a problem restoring a database from a different server. We have 2 Linux ( Suse 8.0 ) Servers with SAPDB 7.3.0.29 Databases in productive areas and one Linux Backup Server ( Suse 8.0 ) with SAPDB 7.3.0.29 too, for worst case ( desaster recovery ). On the backup Server we�ve allready installed a database called backup. This database has different parameters than the productive databases ( only one CPU, less memory and the Datadevspaces are also one 1GB lower, but there is enough place for the datapages ). Now I tried to restore a datasave-file on the backup database, started with the dbmgui ( recovery > database > restore from a medium ) and i became an error -24988 with the description sql error [backup_restore "data" DATA]; -2008, Message not available. I�ve tried the restore with to different datasave - files ( a save as recovery and one as migration ). What can I do? With best regards Ralf Henneke - Rechenzentrum - Mail: [EMAIL PROTECTED] FALKE KG Oststrasse 5 57392 Schmallenberg Internet: www.falke.com _______________________________________________ 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
