By mistake one of my colleague in the office has restored .mdf and .ldf files of another database to production with existing database name. So existing database was overwritten with new backup.

Is there any chance to recover that db back?

xyz database - .mdf & .ldf - restored as abc database (but already existing in production)

  • 5
    Did you not have a backup of the production database? This might end up being a very expensive lesson... – Aaron Bertrand Feb 17 '14 at 17:45
  • 1
    To add detail to Aaron's comment, restore a backup of the actual, correct production database from before the incorrect database was restored. And take away the permissions to do this from anyone who doesn't really need them. – Anti-weakpasswords Feb 18 '14 at 5:27

SQL Server recovery tools cannot help here, they can only recover lost information from database files (mdf, ldf, ndf, bak, trn). You should search for a way to recover overwritten files in Windows

One of the solutions is to use the File History option in Windows. Your Windows version must support it and it had to be enabled at the time when the files were overwritten and

"File History saves copies of your files so you can get them back if they are lost or damaged"

Restore files or folders using File History

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.