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
sql-server
|sql-server-2008
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