MS SQL DATABASE EMERGENCY RECOVERY

Question

I have very very big problem now,

I have ms sql server express 2008 and database called 'TheCubeXT',
and I execute 'drop and create database' on this database (dont ask me why and how).

Is there any way to retrieve data or whole database before this action?
I dont have any backup or other similar file...

That could be save my life now :)

Thanks. 

Answer 1

Hi,

if you dropped the 'TheCubeXT' database (and it was offline or one of its files was offline) and did not delete/overwrite the original files, then they should still exist on disk.

You'll need to know the path to and name of the TheCubeXT's mdf file.

You'll have to ensure sure you don't have a database called TheCubeXT in SQL Server Express. (it sounds like you don't, or if you do, it doesn't have data and in that case you can safely drop it, you may want to backup TheCubeXT database first if it does exist to be on the safe side.)

Update the correct path/filename below and try run the code:

USE master;
GO
CREATE DATABASE TheCubeXT
      ON (FILENAME = 'C:\xxxx\xxxx.mdf') 
      FOR ATTACH;
GO

Answer 2

Sorry there is noway to recover a dropped database,find its recent backup and restore it, you have dropped and created the database ,

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 3

To add to babus comment: Drop and Create in SSMS leads to overwriting the files... So no chance unless you have a backup

Answer 4

Thanks guys, 

I found a solution...

"DiskInternals SQL recover" - this program search only SQL things on hard drive clusters... it found 15 versions of database (per date modified) for me..

So, if you do stupid thing like me, this is totally correct solution!

Answer 5

A backup everyday keeps doctor away!

---

Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu

Answer 6

I would recommend you recover corrupted database owing to following software http://www.recoverytoolbox.com/repair_sql.html utility restores databases since Microsoft SQL Server 2000