Hi experts,

I intend to run informix backup during working hours as I have to run MRP during the nights.

Can some one give me the steps and advise me what is the best way to do this?

Eg.

Sunday at 10am, i run ontape -s -L 0
Monday to Saturday, should i run ontape -s -L 1

What about transaction logs? How and when should i run backup for trx logs?

Further to this, how do I restore the data and logs?

Thanks and regards,

Hello anyone,

Can anyone explain how is the backup and restore steps being carried out?
Which transaction logs backup should i restore?

Thanks and regards,

Hello Kingsto88,
When you perform your level 0 backup, the transactions logs is also backed up, if you are backing up the transactions log also.

I mean, first of all the transactions logs have to be backing up on a physical media, for example a tape. I have found some instalations that the transaction log has been directed to null device. Of course this is a bad practice due to, when a disaster occurs, you have to restore your last level 0 backup and then the incrementals. But if you don´t have the transactions logs backups, you can´t recover the database up to the failure time.

If you want to check this, you can edit the file onconfig.

Finally, if you perform a level 0 backup on working hours, the performance will be affected, mostly when the system will backup large tables.

Hope this helps.

Hi experts,

I intend to run informix backup during working hours as I have to run MRP during the nights.

Can some one give me the steps and advise me what is the best way to do this?

Eg.

Sunday at 10am, i run ontape -s -L 0
Monday to Saturday, should i run ontape -s -L 1

What about transaction logs? How and when should i run backup for trx logs?

Further to this, how do I restore the data and logs?

Thanks and regards,
SQL files can be repaired due to sql database repair (http://www.recoverytoolbox.com/sql.html). The program restores mdf files after power failures, viruses, malicious software. It can show the results of repairing as a table list. Program works under Windows 98 and higher.