Saturday, July 21, 2012 9:07 PM
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 :)
Saturday, July 21, 2012 9:52 PM
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
- Edited by KevinNicholas Sunday, July 22, 2012 5:39 AM clarify offline state
Sunday, July 22, 2012 4:13 AMSorry 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
Monday, July 23, 2012 5:08 AMTo add to babus comment: Drop and Create in SSMS leads to overwriting the files... So no chance unless you have a backup
- Marked As Answer by amber zhangModerator Monday, July 30, 2012 5:52 AM
Thursday, August 02, 2012 6:57 PM
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!
Thursday, August 02, 2012 7:06 PM
A backup everyday keeps doctor away!
Sebastian Sajaroff Senior DBA Pharmacies Jean Coutu
Monday, October 08, 2012 11:30 PMI 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