Monday, March 12, 2012

Possible to undo a restore operation?

I just restored a db from its full backup and then applied its diff backup
and a log backup. Now I need to know how the db looked like before the log
backup was applied. Is it possible to undo the restore from the log backup?
Thanks,
BingNope. You will have to redo the restore and stop one step earlier.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"bing" <bing@.discussions.microsoft.com> wrote in message
news:F9861F7C-1D50-40C7-8B83-3ECCDC838AD8@.microsoft.com...
> I just restored a db from its full backup and then applied its diff backup
> and a log backup. Now I need to know how the db looked like before the
log
> backup was applied. Is it possible to undo the restore from the log
backup?
> Thanks,
> Bing

No comments:

Post a Comment