How to recover after restoring over a wrong database

Hi all,

I'am completely helpless regarding a mistake that occured yesturday.
The problem was that I've restored a Database over an existing one, and
force it to overwrite, but I did not noticed that I was doing it in the
wrong database. Let me explain it with a little sample:

DataBase1
DataBase2

I wanted to restored Database2 with a .BAK file, but I restored it over
Database1 witch I don't have a backup. And the DataBase1.mdf could not
be found anymore. I don't understand what SQL Server did with the
original file, even if I choose the option "Restore over existing
database" the original file should stay there.

I'am currently trying to recover the file with File Recover software,
but still have no luck so far.

Is anyone have an idea of what SQL Server did with the orignal file, or
if there is any chance to getting it back?

Thanks in advance
Dominic

.

Relevant Pages

  • Re: How to recover after restoring over a wrong database
    ... are about to restore. ... wrong database. ... I don't understand what SQL Server did with the ... database" the original file should stay there. ...
    (microsoft.public.sqlserver)
  • Re: Backend Exchange migrate to New Hardware (Server)
    ... Exchange mailbox stores and Exchange public folder stores. ... When you use Backup to restore Exchange databases, ... Storage Engine to restore Exchange database files and their ...
    (microsoft.public.exchange.setup)
  • Backup and Restore Files
    ... What is the best way to backup and restore a runtime database file? ... pszDisplayName As String ...
    (microsoft.public.access.gettingstarted)
  • RE: Restore public folders and companyweb
    ... > where the backup of the database. ... Before you can start to restore the SharePoint Services databases, ... > Microsoft CSS Online Newsgroup Support ... > This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Transaction Log ??
    ... we used to simplify our database restore process: ... every database got their respective backup folder. ... -- get logFileName, FirstLSN, LastLSN list ...
    (microsoft.public.sqlserver.security)
Loading