Missing data recovery
-
I am using a piece of automation software called Taskcentre, this has it's own database. This morning we were having issues with the software and it turns out that an essntial table has been cleared of all data. There are currently no backups for the database and all tasks that have been created over the past year are now gone unless i can find a way of restoring the database to 2 - 7 days ago. I was wondering if anyone had any ideas. David
-
I am using a piece of automation software called Taskcentre, this has it's own database. This morning we were having issues with the software and it turns out that an essntial table has been cleared of all data. There are currently no backups for the database and all tasks that have been created over the past year are now gone unless i can find a way of restoring the database to 2 - 7 days ago. I was wondering if anyone had any ideas. David
-
Any audit tables you could use?
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
Hi Bob How do you mean Audit table?
-
Hi Bob How do you mean Audit table?
Is there any automatic auditing going on to record actions on the table - you know, who added/changed/deleted a record. If so, you may be able to recover your data that way. If there is nothing obvious you could contact the vendor and ask them if they have any suggestions. Otherwise, I'm afraid you have learnt the hard way that you should always do backups.
Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP
-
Hi Bob How do you mean Audit table?
To add to Bob's reply. Not only should you always do backups you should also make sure you can restore them. Once worked in a place that did backups every day. When a hard disk crashed they discovered that the backups would not restore. Three months accounts data lost and had to be manually re-entered from documents. :)
Regards David R
-
To add to Bob's reply. Not only should you always do backups you should also make sure you can restore them. Once worked in a place that did backups every day. When a hard disk crashed they discovered that the backups would not restore. Three months accounts data lost and had to be manually re-entered from documents. :)
Regards David R
Thank you for all of your replies, it seems that I have lost all of the data and as you said I have learnt the hard way that we should keep on top of ALL our backups. Thankfully it shouldn't take too long to recreate the tasks, just means by busy couple of months just got a whole lot busier. Thanks again David