Re: How to recover after restoring over a wrong database

Hi,
Has the datarecovery software worked? Even if the file is overwritten,
you should have at least moderate chances of success.

JK

dominicstpie...@xxxxxxxxx wrote:
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: how to restore a deleted group policy
    ... > performing an Authoritative Restore of the Domain Controller, ... Type restore database and press Enter. ... >> wouldnt the replication from the other DC overwrite the restored AD. ...
    (microsoft.public.win2000.group_policy)
  • Re: Creating & Maintaining Demo Database
    ... On the backup/restore solution, I am concerned that when we make changes ... to the database, the restore will overwrite any of our changes with the ...
    (microsoft.public.sqlserver.server)
  • exclusive access could not be obtained because the database is in
    ... I am trying to restore a sql server 2000 database to an existing database to ... force an overwrite. ... I am trying this from the enterprise manager. ...
    (microsoft.public.sqlserver.server)
  • 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)
Loading