Hello Chris, >IMHO removing backupfiles to restore the desired backupfile isn't very >smart. So I test a little bit.
If you think in terms of tapes, rather then files, it is very common to replace a "backupfile" (==tape) to restore the desired backup. >The following script seams to do what I want: >dbmcli -uUTL -d DATENBANK -u DBO,kennwort >util_execute INIT CONFIG >recover_start NASE DATA ExternalBackupID 1 >db_online >Or I'm wrong? I have 3 backups with the same label "NASE"; so this script >should (and as I said seams to) restore only the oldest (the first) >completebackup. Please don't confuse medium with label. Maybe you should translate medium into backup device (a lot of translation is going on here), rather than into label of a backup. If you look into dbm.knl you will see, that every of your backups has a unique label, e.g. DAT_0001. If you have made 3 backups into the file specified by NASE, you restore with your script the one that is currently on the hard disk under the file name specified by NASE. If you never moved the backup files, you would restore the latest (newest) of the 3 backups. By the way "ExternalBackupID 1" is useless in your case. Best Regards, Tilo Heinrich SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
