Page 1 of 1

restore data

Posted: 22 Feb 2007, 17:06
by happywonderer
I restored data using a sage payroll disc instead of Sage line 50 backup disc and I don't appear to be able to find any sage backup discs in my place of work. Is there any way I can restore to a good version without resorting to reentering all data? The maintenance check is now reporting over 300 errors which can't be fixed.

Posted: 26 Feb 2007, 09:01
by brucedenney
There is nothing you can do.

Be this a lesson to all that see this tale of woe. You can never have too many backups.

http://www.makingithappen.co.uk/backup.htm

http://sage.support.makingithappen.co.u ... backup.htm

restore data

Posted: 26 Feb 2007, 11:35
by happywonderer
Thank you for the information anyway. Luckily the audit trail has retained every transaction for the year (athough over 400 have the wrong transaction no and are listed as purchase invoices) so it may be a simple though extremely tedious task to reenter all the data. I thought there was more than one backup, but can't find the other one. Lesson learnt for ever.

Posted: 26 Feb 2007, 16:53
by brucedenney
Well, if your data is there you could export it to a transaction CSV file.

Fix the data in Excel (correct dates etc)

And then import it all into a rebuilt copy of sage.

The only thing you would need to do is match off the payments on the supplier and Customer ledgers.

Posted: 27 Feb 2007, 01:15
by happywonderer
I have imported the uncorrupted data from Sage to Excel and saved as a csv file, and will try to reenter the audit trail back into Sage. Obviously I will rebuild the data first. This may be more difficult than I expect. The corrupt data will take a bit longer but if I am stuck I will be back to seek more advice from you. Thanks for your help again.