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
