August 6, 2012 at 9:47 pm
Hi
someone has deleted some records from a table and has also deleted the corresponding record from the audit log. It has been 2 months now then I came to know. can i still recover this data? of how can i know what was deleted? my backup model is full and i have a backup which is 2 weeks after the data was deleted. after this i have had everyday backups.
Please assist
August 6, 2012 at 10:20 pm
If you don't have a backup file from prior to the record being deleted, you are out of luck in recovering the deleted records.
August 6, 2012 at 10:34 pm
actually i just came to know that have a backup file which is 6 days prior to the day the record was deleted.
August 7, 2012 at 3:30 am
can i backup the transaction log and use the full backup (6 days) prior to the deletion and restore the database with stopat (a time just before the deletion)? will this work?
August 7, 2012 at 3:31 am
If you have a backup you can recover. But 6 days prior to the delete, you will only get the data as it was 6 days prior, you wont get the data as it was at the time the delete happened.
If data doesnt change your fine, if it does then you wont be able to get the "true" data back.
August 7, 2012 at 3:35 am
raheelr 63130 (8/7/2012)
can i backup the transaction log and use the full backup (6 days) prior to the deletion and restore the database with stopat (a time just before the deletion)? will this work?
Do you have the full transaction log chain from the time of the full backup to now?
August 7, 2012 at 3:40 am
I dont purge or truncate my transaction log so i believe the full log is thier. the size of the db is apprx 19gb and the log is around 23gb
August 7, 2012 at 3:42 am
i have another backup which is 8 days after the deletion. will this work with transaction log?
August 7, 2012 at 3:44 am
Do you backup the transaction log or not? What recovery model is the database?
August 7, 2012 at 3:48 am
my recovery model is full and i dont backup the transaction log. this database is just 3 months old and ever since no transaction log backup has been done, only full
August 7, 2012 at 3:52 am
Well in that case, if you have never done a transaction log backup, the actual log is the chain.
So backup the log, restore the 6 day prior db to a different name with norecovery, restore the log using stopat.
Also start taking transaction log backups, otherwise if you would have lost the whole DB you would of only ever recovered to the last full database.
August 7, 2012 at 3:57 am
thank you so much. so if i undertsand it correctly i have to do this now:
1. backup the transaction log from the production database (where the data has been deleted)
2. restore the 6 days prior backup to the test environment
3. restore the log with specified criterria in the test environment
4. check to see if the records exist
5. backup the test environment database
August 7, 2012 at 4:01 am
can i just restore one table i want using this option you have advised? do you have any sample scripts which could be of assistance.
August 7, 2012 at 4:07 am
No you cannot restore a single table, it has to be the whole database.
August 7, 2012 at 4:10 am
ok thanks. any script which can help me achieve this please?
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply