hw to recover a dropped table

anjisql · #1 (**permalink**) 12-09-11, 02:45

unfortunatly i dropped my table in sqlserver.
hw to i recover that table?

aflorin27 · #2 (**permalink**) 12-09-11, 05:35

from a backup

shammat · #3 (**permalink**) 12-09-11, 05:40

Quote:

Originally Posted by anjisql

hw to i recover that table?

Do you mean which hardware (=hw) you need for the restore?

Pat Phelan · #4 (**permalink**) 12-09-11, 13:07

If your databases is in FULL RECOVERY mode you have several options. If the database is running in SIMPLE RECOVERY mode, you need to recover the table from a backup.

-PatP

Internet Services

Web Development

Digital Marketing

Consumer Tech