Re: How to recover after restoring over a wrong database

Yes you're right, we place a support call at Microsoft yesturday, and
after replicating the situation it's look like SQL Server delete the
original files even if it's not the same name has the .mdf and .ldf you
are about to restore. We've lost a lot with that incident.

I still cannot beleive we did not had any backup of that DB. If
you're not doing any disaster situation you never know what you can
loose when something bad happens. And trust me we will do a disaster
simulation just after we are finished with the reconstructing of the
DB.

Dominic
Jonathan Roberts wrote:
dominicstpierre@xxxxxxxxx wrote:
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


I hope I am wrong but I think you're out of luck. I guess everyone has
to learn about backups one way or another. Good luck...

.

Relevant Pages

  • Re: unable to start SQL Service ... error code 3417
    ... How about just create a new instance and restore databases to the new instance? ... I wouldn't go with restoring master from another instance. ... The supported route is to rebuild your master database, start SQL Server in single user mode, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: HELP!!! restore database - left in loading state?? PLEASE H
    ... RESTORE DATABASE WITH RECOVERY ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore Master DB to New Server
    ... the user database will be suspect. ... Just drop them and then do the restore. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
Loading