July 15, 2014 at 3:54 pm
I am wondering if I can get some help.
I have a DB backup which was taken at 11:05PM on 7/14/2014. I also have Tlog from 3:00AM (7/14/2014) all the to 4:00PM(07/15/2014). Tlog runs every hour. Someone deleted something between 1 and 2 PM yesterday and now he wants it back. What would be the best approach to get that data?
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
July 15, 2014 at 4:13 pm
Well, I would want to know why they want it back. That is just to hear him/her give me an answer to see if it is worth me spending that much time to get it back. What was deleted and if it included cascading deletes will dictate how long it will take you to get it back for him/her.
To get it back, you will need to restore the backups to another database since you likely do not want to overwrite the current database. Restore to that point where the data still existed. Once restored you need to extract it and then put it back. Which again based on what the delete was will dictate how difficult it can be to put back.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
July 16, 2014 at 2:20 am
As said above, you'll have to restore to a new database and then retrieve the data from there. You don't want to restore over your production systems since they'll have progressed far past the point when the issue occurred. Here's an article on how to do the point in time recovery[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply