You will want to restore your most recent backup of the database to another database name or to another server, then script out the database and then copy the data from the restored database to the production database which is missing the table.
If your database is in full recovery mode or bulk logged recovery mode you can use a product like <a href="http://www.quest.com/litespeed-for-sql-server">Lightspeed for SQL Server</a> or <a href="http://www.lumigent.com/">LogExplorer</a> to find the entry in your transaction log for the DROP TABLE command and roll back that command. Doing this will get back the table, but you will still need to get the data back out of an existing backup that you have.
If you have Lightspeed for SQL Server you can restore just that table from the backup file instead of restoring the entire database.
Last Wiki Answer Submitted: March 17, 2008 6:31 pm by Denny Cherry64,520 pts.