Sql-server – How to recover a dropped table from SQL Server Express 2005

sql serversql-server-2005

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.

Best Answer

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.

Related Topic