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.
migrated from stackoverflow.com Nov 10 '10 at 14:30
This question came from our site for professional and enthusiast programmers.
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.
That's exactly why all RDBMS have log files, so you can recover from disasters like these.
In this case, you are your own panicked co-worker.