For what it's worth, here is my backup operation, which meets all of my needs.
Considerations: 1. I don't care about backing up system tables. I can easily rebuild the database structure after a catastrophy via a script file. All I need to recover is the data. 2. I don't have any users in the db (other than the default user I entered when I created the database)...I track all of that in a table. Backup Procedure (really just an export of data): A batch file (Windows) is run that contains this command: repmcli -d DATABASENAME -u DEFAULTUSER,PWD -b c:\my_export.cmd The file it calls, my_export.cmb, contains this command: tableextract user outfile my_tables This runs in a split second, while the database is running, and produces 2 files: my_tables0000 my_tables0001 which contain all of the data I am interested in (again, just my data tables). Restore Procedure: A batch file is run that contains this command: repmcli -d DATABASENAME -u DEFAULTUSER,PWD -b my_import.cmd The file it calls, my_import.cmb, contains this command: TABLELOAD user INFILE my_tables outfile import_errors This runs in a split second, while the database is running, and imports the data I backed up PERFECTLY. Last Step (you'll go nuts if you forget it!!!): After using the above restore method, you have to restart the logs. To do this, I just run the standard backup that's installed with the database: dbmcli -d DATABASENAME -u DEFAULTUSER,PWD medium_put completeF c:\databack FILE DATA 0 8 YES dbmcli -d DATABASENAME -u DEFAULTUSER,PWD -uUTL -c backup_start DATA At this point, I am back 100%. For what it's worth... Scott Murray _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
