on 03-09-2015 1:39 PM
Good morning,
I'm facing a problem during a MaxDB Database restore.
There is a database with size of 1 TB (32 Bits) that I need to move it to an other server (64 Bits).
Actually, I did a restore from the last backup (COMPLETE) and it finished successfully. I don't have INCREMENTAL backups after this last COMPLETE backup and I need to apply all last LOG Backups into the database for consistence.
My problem is that in the new database, the backup history was lost and it does not recognize the log numbers.
Do you have any idea how to restore these LOG backups?
Thanks in advance,
Ricardo
Hi Ricardo,
Can you please post the exact error? Also you should bear in mind that restore must be done with both FULL and log files at once.
BRs
Martim.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ricardo,
Why there should be backup history in the newly created database? I mean right now you are doing restore to the
newly created database, the backup history only contains the restore action, but no backup history for the log backup which is the source database
For to continue to apply log, you can perform
recovery from a medium and chose a backed up log. Please do not worry about if you chose an early log number,
the recovery process will automatically skip the log which does not need to apply and continue to look for the next one.
You can perform restore by using database studio:
right click the database node-> recovery -> recover a medium -> chose a log template -> then give a log number
Best regards,
James
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ricardo,
please describe how your backup works.
Here we make a backup to a filesystem, automatic log backup as well and copy all files to tape.
regards,
Sandro.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Ricardo,
Check if you have dbm.ebf & dbm.ebl files on your source system and try to copy those to your target server and modify as per your new target system to create backup history.
and then apply the logs. Also you can try to restore using database management studio(dbmgui).
Let us know the outcome.
regards,
Ram
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.