Tuesday, March 20, 2012

Recover lost data after wrong backup restored

I have accidently restored a SQL database (using Force restore over existing
database in EM) using a backup which was 1 month older than the latest
backup, and have therefore lost some important data from the existing
database. Is there any way that I can recover the lost data?
Thanks for any help.
Seen from SQL Server's viewpoint, the data has been physically overwritten.
Either hunt down a later backup, or see of there is any OS or possibly SAN level utility that might
help you here (I wouldn't have much hope for this but think it is at least worth mentioning).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Williams" <johnwilliams_esquire@.NOhotmailSPAM.com> wrote in message
news:uSRIcb5rEHA.536@.TK2MSFTNGP11.phx.gbl...
>I have accidently restored a SQL database (using Force restore over existing
> database in EM) using a backup which was 1 month older than the latest
> backup, and have therefore lost some important data from the existing
> database. Is there any way that I can recover the lost data?
> Thanks for any help.
>
>

No comments:

Post a Comment