October 22, 2008 at 9:21 am
Accidentally one record has been deleted from our database yesterday,we don't know how or who has done that.We want to restore one record into the database instead of restoring the whole database.Do we have to check all the tables and see if the record is missing and restore it back,because some tables are showing up that record and some are not.It indicates us that somebody has deleted that record from some table accidentally and we almost have like 45 big tables.
Is there any simple way to restore the deleted record in tables which it is deleted from?
October 22, 2008 at 9:28 am
Restore the the database to another location (database) and then select from the restored database to the production database.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 22, 2008 at 11:00 am
Jack Corbett (10/22/2008)
Restore the the database to another location (database) and then select from the restored database to the production database.
I agree with Jack, but you'll have to figure out which tables are missing the data. You say one record is missing, but then you say you have 45 tables that might contain the data? Could you post more information about your database and how the tables are related?
Greg
October 22, 2008 at 11:04 am
Or buy a log reader tool (ApexSQL, Lumigent) to read through the logs to undo the deletion.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
October 22, 2008 at 12:05 pm
all the tables are related to each other in the database,some of them are showing the record but others are not showing it.I will give you an example:
I can see that record in table empcomp(which has all the information regarding company like empid and emppaygroup etc) but I can't see his record in emppers(which shows all info regarding his personal info like his first name,last name etc)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply