I accidentally restored a SQL Server 2008 database with a wrong backup. Is there any way to undo this and restore to previous version?
A:
Unfortunately no. The only solution is to do another restore with the proper backup file(s).
Thomas
2010-04-05 00:34:33
A:
As I wrote at: http://serverfault.com/questions/129290/undo-database-restore-in-sql-server-2008/129291#129291
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
2010-04-05 01:00:06