Delete a company

cmn

Hi!

If I delete a company... what happens actually? I would like to know what happens with the data and the keys. Do they disappear totally? Or there is a way to view the data?

Thank you!!!

:-k

Urmas

The set of tables what are belonging to this company are deleted.

It means that everything is deleted - including data and keys.
The table descriptions are kept in objects table, so they will remain intact.

Torben

Actually - I guess - only the nodes in the database tree are set to nothing (nil) thus leaving the data intact but the space they occupy marked as free space. So a new writing to the DB can occour in this new freed space.

Best rgds

Urmas

Yes - you most probably are correct. The information is not wiped out - the deletion process is too quick for that.
For normal circumstances out there it naturally does not matter much as the recovering of the information may cost more than hiring somebody to key the whole data back into to the database... , so we can consider the deleted company data to be gone forever.

Torben

I agree

facade

There is a licence for restoring that kind of stuff - it should be included as C/DART - i have never had a pleasure to test that - but what i've heard it's a very wide tool for every kind of "strange actions" that you normally wouldn't even think of. Unfortunately it is not in NSC licences so - maybe somebody from Microsoft could explain that a bit :whistle:

Ian_piddignton

C/DART is used for repairing corruptions to the database. It effectively looks at the database's internal version number(eerytime somthing is posted it gets a version stamp) and then tries to test to that version to see if it is OK.(this a simplified description of C/DART)

I don't think it is going to be able to recover the company unless it is very recent. even then it may not work.


if you have deleted a company then the easist way to get at the data around that comapny is go to a back up. Before deleting a company form the databse take a backup and confirm it can be restored.