Re: Backup an Informix database

Indeed the data is blown because what you are doing is saving different tables at different times with different changes posted to it. If you want to do a correct backup of the informix database you need to put it in Quiescent or offline mode. When you do that you data is ok. Depending on the size of your database it might take a while. We run a backup every night at 1AM to 4AM and take informix down every night at that time. You can also do a level 0 backup of the database to disk which is very quick , and then save the level 0 backup file to tape. Christophe DC wrote: > Hello everyone, > > On our NT-server we run the program 'Baan'. For backup our NT-stuff and > also the Informix-database of the program baan, we use 'Seagate Backup Exec > 7.0'. Now, the problem is, when the Informix database-services are > running, he backups the database who changed permantly (because some users > make changes or the services makes changes). Is it possible that the > data-integrity isn't good when we restore our full-backup ? How does that > work in fact ?? > > Many thanks on beforehand to the people who answer these question. > Christophe DC > -------------------------------------------------------------------------- > If you want to reply directly to by Email, > please remove the 'X' from my Email-adres. > --------------------------------------------------------------------------