If you only recover your data and do a restart then the actual log volume still contains all changes inclusive your "drop table" statements. This is the normal recovery behaviour because you want all changes redone.
What you are expecting (the tables are existing after recovery the data) implies a point in time recovery after the data recovery. Then you have to choose a timestamp where the tables still exist. Another way to this is to delete the log. You can do this by re-install the databas instance on the basis of you last data backup where the tables where existent. Uwe > -----Original Message----- > From: Scott Murray [mailto:[EMAIL PROTECTED]] > Sent: Donnerstag, 30. Januar 2003 23:40 > To: [EMAIL PROTECTED] > Subject: Restore won't work.... > > > i apologize up front, but i've read the manuals, and checked the list > server, and search the archive, but i am lost: > > 1. > I have a db with approx 10 tables that I can see under the appropriate > username in the tables section of SQL Studio. And there is data in the > tables that I can query. > > 2. > i run this backup: > dbmcli -d mbm -u dbm,dbm -uUTL -c backup_start DATA > > which returns... > OK > Returncode 0 > Date 20030130 > Time 00173257 > Server murraycom > Database MBM > Kernel Version Kernel 7.3.0 Build 024-000-000-000 > Pages Transferred 656 > Pages Left 0 > Volumes 1 > Medianame data > Location c:\data\mbm\datasave > Errortext > Label DAT_00005 > Is Consistent true > First LOG Page 496 > Last LOG Page > DB Stamp 1 Date 20030130 > DB Stamp 1 Time 00173257 > DB Stamp 2 Date > DB Stamp 2 Time > Page Count 638 > Devices Used 1 > Database ID murraycom:MBM_20030130_172527 > Max Used Data Page 651 > > and I can see the size of c:\data\mbm\datasave has increased. > > 3. > I drop the 10 tables. > > 4. > I put the db into Cold mode. > > 5. > I run: > dbmcli -d mbm -u dbm,dbm -uUTL -c recover_start DATA > > which returns > > OK > Returncode 0 > Date 20030130 > Time 00172732 > Server murraycom > Database MBM > Kernel Version Kernel 7.3.0 Build 024-000-000-000 > Pages Transferred 656 > Pages Left 0 > Volumes 1 > Medianame data > Location c:\data\mbm\datasave > Errortext > Label DAT_00002 > Is Consistent true > First LOG Page 482 > Last LOG Page > DB Stamp 1 Date 20030130 > DB Stamp 1 Time 00172645 > DB Stamp 2 Date > DB Stamp 2 Time > Page Count 638 > Devices Used 1 > Database ID murraycom:MBM_20030130_172527 > Max Used Data Page 651 > > 6. i put the db in warm mode, BUT I can't see the tables, and > I can't query > them. > > I've restart the db service, the server, etc., but I just > can't recover the > data. > > Can someone help me...thank you so much. > > Scott Murray > > _______________________________________________ > 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
