I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version?

-Vivek

link|improve this question

40% accept rate
feedback

2 Answers

up vote 5 down vote accepted

No. You've replaced what's there with your restore. You would have to treat this the same as someone dropping your database - go to the most recent full database backup you have and then restore all subsequent log backups.

Sorry... you probably have that sick feeling right now. I feel bad for you.

link|improve this answer
it's on a windows 2008 server. any chances of retrieving a lost file? – Vivek Apr 5 '10 at 1:09
Nope, sorry.... – Rob Farley Apr 5 '10 at 1:49
feedback

r u saying that you restored database "b" to "a", or was it just the wrong date for the backup? If so do you have a more current backup? I know this sounds stupid but .... I won't say the obvious.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.