SQL Server - Is it possible to recover a dropped table?

Asked By Ravi Kumar on 03-Jun-04 01:11 PM

Hi All,
       Accidentally I have dropped a table and that is the main table for my application.
I dont have a backup of it. Is there any way to recover it.Please help me guys.
Thanks,
Kumar.

Are you sure you don't have a backup

Asked By Robbe Morris on 03-Jun-04 01:16 PM

When a database is created in SQL Server, it is set to Full Back Up by default.  So, your table should be available by restoring the transaction backup.  Try going to the "restore database" options by right clicking on the database name in Enterprise Manager and selecting All Tasks.

You know, I dropped a table

Asked By Dexter Dotnetsky on 03-Jun-04 04:02 PM

on my foot once, and I don't think I ever recovered. Lots of luck.

Are you sure Transaction log can restore a table?

Asked By Peter Bromberg on 09-Jun-04 05:14 PM

I thought it only held the transactions, not the whole database schema. That's what backups are for. 
In other words, in the Full Recovery model, SQL server writes every update, delete etc. but it doesn't actually save a copy of some table or table schema script from which you could restore a dropped table.
I suppose its possible to manually recreate a table that was dropped by examining the log transactions, but its sure not something I'd want to have to do.

vasuki replied to Ravi Kumar on 21-Jan-11 04:01 AM

FLASHBACK TABLE table_name TO BEFOR DROP;