Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Something disastrous happened to me. I accidentally dropped my important table from SQL Server 2005 Express DB. Is there any way to recover that table with all records? Can DB Log file help? I have a backup until yesterday, and today's 6 hrs of transactions are lost.

share|improve this question

migrated from Nov 10 '10 at 14:30

This question came from our site for professional and enthusiast programmers.

if it's that important, then why is there no backup? – Gerrie Schenck Nov 10 '10 at 14:20
we have day end backups for this DB, but this happened in afternoon – RAJ K Nov 10 '10 at 14:45
up vote 2 down vote accepted

I'm going to add this as an answer even though it's not a fix-all (unfortunately, you need to recover data that's not backed up).


SqlExpress doesn't have all the nice features the full version does (including backup plans), however, ExpressMaint is a great solution that you wire-up to your task scheduler via command-line execution. You can have it run as often as you want. It works great.

share|improve this answer

That's exactly why all RDBMS have log files, so you can recover from disasters like these.

For Sql Server 2005 start here with a log file recovery process. And here is another resource. The starting snippet from that article:

A coworker calls you in a panic because he accidentally deleted some production data, and he wants you to restore the lost records. ...

In this case, you are your own panicked co-worker.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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