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
Asked
Active
Viewed 2,015 times
1 Answers
6
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.
Rob Farley
- 688
- 2
- 5
- 13
-
it's on a windows 2008 server. any chances of retrieving a lost file? – Vivek Apr 05 '10 at 01:09
-
Nope, sorry.... – Rob Farley Apr 05 '10 at 01:49