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.