-2

I'm running an application on windows server that connect to a SQL Server database.

Today, when I opened SQL Server Management Studio, I was surprised the database is not in the list of the databases!

I don't know what's the reason. I searched in the server files but I can't find the database and also in the recycle bin.

I put my database in C:\db\myWeb.mdf and suddenly it's been removed!

Can anyone tell me how to recover the database?

UPDATE: I used stealer phoenix to find the database files deleted on disk but unfortunately i didn't find the db then i tried to add new database with the same name of the deleted db but SQL management studio said that the database "MyWeb" already exist! that's mean it's some where in the server but i couldn't find it ?! .

user2728312
  • 39
  • 1
  • 7

1 Answers1

3

The only thing you can do when the actual database files are missing is restore a backup of your server.

Optionally, when you have no backup, you could use a hard disk recovery tool (like Runtime GetDataBack to find the database files deleted on disk).

Patrick Hofman
  • 153,850
  • 22
  • 249
  • 325
  • I used stealer phoenix to find the database files deleted on disk but unfortunately i didn't find the db then i tried to add new database with the same name of the deleted db but SQL management studio said that the database "MyWeb" already exist! that's mean it's some whare in the server ?! . – user2728312 Jun 09 '14 at 10:28
  • Then recovery is the only possibility. You can't prevent data loss in this case. – Patrick Hofman Jun 09 '14 at 10:30
  • what do you mean by recovery (recover from what) ? – user2728312 Jun 09 '14 at 10:32