Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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
add comment

migrated from stackoverflow.com Nov 10 '10 at 14:30

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

2 Answers

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).

SCHEDULE REGULAR BACKUPS

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
add comment

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
add comment

Your Answer

 
discard

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.