Dear all,
we currently try to find out the secrets of the backup / restore
features of SapDB.
We are using SapDB 7.3.0.20 on SuSe Linux and Win NT.
On both systems we have the following situation and behaviour.
We have a database with some tables belonging to user esad.
1. Backup:
We create two complete backups using the Database Manager (GUI)
a) Migration
b) Recovery
2. Deleting tables
We delete all (except of one) tables of the user esad.
3. Restore:
Set DB to cold.
Restore of one of the two backups (no matter which one).
Restart DB (to warm)
All steps are running without any error messages.
The result is that none of the tables we have deleted in step 2 are
available and that's our problem.
The only way to get the deleted tables into the database is to install
the DB once again and do a recovery using the following commands:
dbmcli -d <DB> -u <user>,<pwd>
util_execute INIT CONFIG
util_connect
reecover_start <RecoveryBackupMedia>
db_warm
Are there any good informations available how backup / restore is
working ?
Thanks and
best regards
Hannes
--
Hannes Degenhart GPS - Gesellschaft zur Pruefung von Software mbH
Hoervelsinger Weg 54 D - 89081 Ulm - Germany
Pho. +49 731 96657 14 Fax. +49 731 96657 57
mailto:[EMAIL PROTECTED] Web: http://www.gps-ulm.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
