Skip to Content
0
Former Member
Mar 24, 2009 at 07:41 PM

DB Restore

45 Views

Hello All,

we have a question about the correct procedure to restore a DB on MaxDB.

the last friday night we did a full online backup on our MaxDB (7.6.04.16) DEV instance to test the recovery procedure, we made a changes in our DEV system and then we proceeded to recover the DB, we found that the restore didn't work correctly due the changes persisted even after the restore the last backup in the system. the procedure was:

1. we stop the SAP instance

2. complete online backup on DBMGUI

3. restart the DB

4. we start the SAP instance

5. we made a changes on SAP DEV instance

6. we stop again the SAP instance

7. the DB was set on Admin state

8. we select recovery --> select the last backup --> restart

9. we follow the steps of restores procedure in DBMGUI, the restore ends sucesfully

10. the DB was set on online state

11. we start teh SAP instance

12. we check whether the changes in the system, there was still finding that changes persisted on it

what is the correct way to restore the database on MaxDB?

Thanks

HEPC