Recover Dropped Table

Tip: Skip this step if you are running the Guided Tour against a SQL 2005 instance; the Salvage Dropped/Truncated Table Feature is supported for SQL 2000 only.

To recover the service table, simply:

  1. Select 'Salvage Dropped/Truncated Data' in the left-hand toolbar.
  2. Type in 'Service', the name of the dropped table
  3. Select a file name for the recovery script
  4. Click the 'Create' button to build the recovery script

You can execute the recovery script in Log Explorer using the 'Run SQL Script' function as before.

In addition, Log Explorer provides the 'Salvage' dropped table function directly from the 'View DDL Commands' screen.

 

Click 'Next' to continue.