Sage 50 company overwritten, recovered files, no backup

[joshtheitguy]

Hello!

I am the sole IT guy for a company with 5 accountants.

Current set up for sage 50 accounts is;
line 50 2011
companies hosted on server 2003
currently unusable
one very old backup

One of our users managed to overwrite our company data with a nice, clean, blank set.

We usually have tape backups of the data, but the tape drive had failed before the christmas holiday and is yet to be repaired.

I used 'active@ Undelete' on the HDD (on the windows server 2003) with the company data on, and found with it a folder '~OLDDATA' in the company. I restored this data and attempted to copy the files over a working (but old) backup of the ACCDATA.

I copied over a backup due to certain files being unrecoverable, namely 'setup.dta'.

When attempted to login to sage 50 with the recovered ACCDATA, after requesting login details, which do need to be valid as the logins used previously, sage immidiately crashed out without an error.

After a lot of trial and error, I found deleting (or replacing with the backups version) TABLEMETADATA.DTA allows me to log in, but there are no values e.g. customers, suppliers, bank..

I can however view the Financials via Modules>Financials, and these are the correct transactions up to date.

My question is how are the Customers, Suppliers, Company, Bank fields mapped to sage 50?

I'm hoping there may be one, or a bunch of, file(s) stopping it reading the data due to me recovering the wrong version?

Any help would be great.

Let me know if i've not included any data that is useful if you can think of any solutions/workarounds.

Thanks,
Josh

[leyburnsolutions]

All the missing information is in separate data files so, for example customers are in SALES.DTA and suppliers are in PURCHASE.DTA - all the data files are held in the ACCDATA folder so, if that was recovered, all the data should have followed.

Unless you can recover the entire contents of the ACCDATA folder the data is probably going to be irreparable (at least not without a huge amount of work by a Sage Developer)

John

[brucedenney]

I think you are in a big mess and you are not going to get out of it on your own unless you find a good recent back up.

It may be possible to recover the situation to some extent.

If you were to come to me to look at recovering the data for you professionally, then providing the audit trail is intact, even if it is only the splits and the headers, it could be rebuilt with blanks in the missing places. I would look at it and let you know the viability or cost of a repair without charge. The cost of reconstruction is hugely dependant on how much data is there and how much we can reconstruct, it would not be less than £400 to do. It may be possible to splice the damaged data onto the old good backup or fix missing data in the current data set using data form the old data.
http://www.makingithappen.co.uk/support ... rvice_.htm


I will take your story and another endorsement of my Backup Guide
http://support.makingithappen.co.uk/gui ... _guide.htm