0

Is it possible to recover an SQL database if its associated files have been permanently deleted by mistake?

![enter image description here]1

Improve this question
3
  • Have you also deleted the transaction log files? Any database backups to work from? Commented Jul 15, 2015 at 12:04
  • It seems there is no transaction log file present. When I right-click on the database in Microsoft SQL Server Management Express, Tasks -> Restore is grayed out. Commented Jul 15, 2015 at 12:15
  • First time i ever saw a literal version of "screenshot". Commented Jul 15, 2015 at 12:46

1 Answer 1

Reset to default
1

You can recover the database using:

  • full database backup stored somewhere your admin chose to be stored
  • a tape backup you don't know even exists, but your datacenter admin knows
  • a database mirror (you have to break the mirror first)
  • a database backup (copyonly?) your developer has somewhere as the base for his dev work
  • an old version SQL Server you have just migrated from
  • parts of the database hashed all over the xml files your developers store somewhere on their PCs
  • ...
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

You forgot: Really good memory. Waking up from the nightmare in which the DB was deleted in the first place. A time machine.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.