Post
Ask Question

Database Recovery (1-1): Restore a Table from a Backup Database through Restore/Export

I made these several articles as a series as Database Recovery:

Introduction

In the previous article, Clone Database From One Instance To Another In SQL Server, we discussed 5 different ways to do so:

  • Attach/Deattach
  • Backup/Restore
  • Export/Import --- Export/Import Wizard
  • Scripting --- Generate Scripts Wizard
  • Copy Database --- Copy Database Wizard

Now, we have an issue; in a long time restored database, I accidentally deleted one table, actually, deleted a bunch of records in one table. The database has changed a lot since the last restore, while the table with deleted records is not. The solution could be that we just recover the relative table from the original database

Solution

We could use anyways or combinations introduced from the article, Clone Database From One Instance To Another In SQL Server, while in this article, we will use Restore/Export to recover the Table:

  1. Restore your Original Data

    • From your DB backup on another server or on the same server
  2. Restore the Table by Export:
    • Right-click on the new restored database and select Task --> Export data
    • Select: Source server and database ---> destination server and database
    • Choose your dropped table and export it to the required server.

The restoring database is straightforward forward, and introduced in the previous article, we will demo the Export details:

Right Click Database

Choose Export, 

Get the Export Wizard: Next

Choose Data Source:

Choose Database Name

Choose Destination

Choose Destination Database Name

Choose Copy Data from one or more Tables or Views:

Select the Table you want to recover:

Click Next

Click Finish

Done successfully.

References


Similar Articles