Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

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.

share|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

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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