question

it1024 avatar image
it1024 asked

retreiving recods from an old backup

Hi all, Working on CRM2011 I found that some old records have been deleted through bulk delete task a month ago. I have got a SQL backup (.bak file) from the day before the deletion happened. I only want the records which have been deleted from that specific table to be added to the same table now because full restore would delete all the new data from that day on. I don't know where to start and what scenario I should follow. Your help would be appreciated. Thank you
import-datasql2008r2
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
At a high(ish) level, what you need to do is restore that backup to another database. Then you can query it for the missing data and work out how to put that data into the live database, complete with referential integrity
5 Likes 5 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.