How can we recover/restore lost/overwritten data in our MSSQL 2008 table?

Posted by TeTe on Server Fault See other posts from Server Fault or by TeTe
Published on 2011-04-14T11:14:23Z Indexed on 2012/12/07 23:15 UTC
Read the original article Hit count: 155

Filed under:
|

I am in serious trouble and I am seeking professional advices here.

We are using MSSQL server 2008. We removed primary key, replaced exiting data with new data resulted losing our critical business data in its child tables on MSSQL Server. It was completely human mistake and we didn't have disk failure.

1) The last backup file was a month ago which means it is useless.

2) We created Maintenance Plans to backup our database at 12AM everyday but those files are nohwere to be found

3) A friend of mine said we can recover from Transaction Logs. When I go to Task>Restore> Transaction log is dimmed/disabled.

4) I checked Management>Maintenance Plans. I can't find any restored point there. It seems that our maintenance plan hasn't been working.

Is there any third party tool to recover lost/overwritten data from MSSQL table? Thanks a lot.

© Server Fault or respective owner

Related posts about sql-server

Related posts about sql-server-2008