Recover the Table Data

Question

Recover the Table Data

Saravanan_tvr

SSCarpal Tunnel

Points: 4558
More actions
January 10, 2011 at 11:12 pm

#232845

Dear All,
Unfortunately,I have deleted the table all data, but i do not have the recent backup , is there any way to recever the table data?,
Note , I have full recovery also

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

You can restore your Full Backup as a different name, and insert the data back into your empty table from the backup with a insert into (select ....) statement.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Saravanan_tvr SSCarpal Tunnel Points: 4558 More actions · Answer 2

Bu My backup was two days older than lost date, so i am struggling.

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

you can only recover back to the last data that you backed up.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 4

Since your database is in full recovery mode, can't you take a tail log backup and do a point-in-time restore right before you deleted the data?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

Do you have log backups? An unbroken chain of log backups from the last full/diff backup up to the point that you deleted data?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Grant Fritchey SSC Guru Points: 398886 More actions · Answer 6

Kathi's article on recovery to a point[/url] in time is very good. I have one too[/url]. Basically, assuming you can answer Gail's question with a "yes" this is what you need to do.

"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