Restoring specfic company in Progress

Assuming that this is a multicompany database, any kind of per company dump and restore would necessarily be application specific, not something that would be addressed with any generic Progress utilities. It is possible to restore a backup of the whole database, write specific code to dump data for specific tables for just the one company, delete the data for those tables for that company in the regular database, and then load the dumped data .... but you'ld sure better know what you were doing and what implications there were in terms of relational integrity between tables. Generally, you would be far better off merely correcting the errors with the application tools to insure relational integrity.

If you are wondering what I mean by the relational integrity, one example from an application I am familiar with is that Accounts Receivable items were by Company, but Customers were not. Customers had total AR Balance and other summary figures, so if one changed the receivable items for one company by any means other than standard application tools, then the Customer totals would be off.

Thomas,

Thanks for your input. I know about relational integrity.

Good. But, maybe it will help someone else.

What is the nature of the error? It would seem to have to be pretty drastic to want to throw out a whole body of entries.

Is this something that all happened one day and was discovered right away? If so, you could have used after imaging to roll forward to the point before the mistake. It would throw away all work for other companies after that, but it could provide a clean break.

You alos have an option to restore the database into a new intstance and extracting the applicable information from this restore and updating the production database.

Depending on your firms knowledge of the application/data layout this may also be a valid option.