Hi,


We are Upgrading to V9.5 Workhgroup Server edition from V8.1.9 WSE

It seems that on this upgrade are skipping taking Offline Backup of database POS. (To Save Time)

I don’t really recommend that but the point was to use online backup already taken as a scheduled job.



ONLINE backup starts at 1:00am and finishes by 2:45 am. The LOGS are included.

We restore the database and rollforward to the END OF LOGS.

ROLLFORWARD DATABASE POS TO end of logs and stop OVERFLOW LOG PATH (G:\POS_Daily_Backup')

This is only for the situation if we have to rollback to 8.2.



We are going to stop at 5:30 am whereas online backup finishes @ 2:45 am.



So, I will copy the all the logs after the last LOG included.



Question:

To rollforward to last transaction committed till 5:30,
Do I have to issue another rollforward till 5:30 am (2:45 -5:30) ??
or the same will rollforward till 5:30am .



Please advise me.

DBFinder

You will not be able to use an Online Backup on V 8.x and restore it to V 9.5 and rollforward. V9.5 cannot read the logs from V8.x. You will have to do an offline backup. There is no other option.

Andy

ARWinner,

I meant tom say, just in case I need to roll back to 8.2.


Thanks

DBFinder