Hello,

We have BaaN IV c4 with sp 11 running on Win NT 4.0, we r taking level 0 backup daily of database ( infomix ), now my doubt is in case if there is a server crash , that is O/s rash then how can i restore it back ???

what all things i should do as far as Win NT O/S is concerned, any disks to be made, any other type of O/S backup should be taken ???

Waiting for your reply.

Hi Learner,

Your vision is good, Technical person should think on it for better service to their organisation. You should take this as a implementaion part, probably if the OS is NT. You can move to "Disaster Recovery Plan". I faced this problem, so can give some inputs to you.
If your database and application is on same server, think to separate it, this will minimize the problems.
If you have resources why not make the whole environment highly available by seting up a STANDBY Database, I am not informix person, I don't know more on informix.
Make frequently ERD.
Imagine if the server crashed, you have to follow the following steps:
1. Fresh installation of NT (Format disks/RAID configuration is different issue)
2. Installation of NT SP.
3. Create users.
4. Installation of Informix.
5. Update last backup data or recover database upto last event.
6. Install BaaN
7. Revalidate it. (After lot of contacts to support)
8. Install SP (11 SPs in your case)
9. Install Porting Set
10. Set Environment Variables
11. Import company specific customizations, etc.

This may take 2-3 whole days.
One more way to avoid above steps is to use HP with OBDR (One Button Disaster Recovery) tape drive. I am using this from last 2 years, since no issue. And I have recovered two times entire OS. The only limitation is, you have to stop all the services.
Thats it.

-Suhas

If you don't go with a full OS backup setup (this includes all) as suggested, I would make sure that at least I would have, besides the DB, a Baan backup (all related directories) because with that you can skip a lot of steps by
- restoring back the Baan directories
- re-installing the portingset to re-create the registry entries
- relicense it

Hi,

I surely agree that it would have been much better senerio in case where my application & database r on diff. servers, but unfortunately because of certain resource constraints we cannot go ahead with it.

Yaah i have already taken Baan, Win NT Registry as well as informix directory backup on DLT tape.

Although i took Win NT , but while doing so it said some of the files could not be copied because "files r in use", even closing many services

i took all this backup using backup utility of Win NT.
is there any other way to take NT backup ?

and one more doubt i have in mind , right now my o/s NT is having services pack up to 4 , as it is advisable to have latest services pack installed (i think 6), if i install it and the server doesn't start or start with that blue screen (page fault) then what should i do ?

any precuations i should take before installing these O/S service packs ? 1 is ERD and any other thing also to be done ?


Waiting for your reply.

Learner