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 Lightspeed for SQL Server or LogExplorer 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.

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window