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
Add a comment |
1 Answer
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.
- it's on a windows 2008 server. any chances of retrieving a lost file?Vivek– Vivek2010-04-05 01:09:35 +00:00Commented Apr 5, 2010 at 1:09
-