Restoring a single table

• MProuty

  Newbie

  Points: 1

  More actions

  August 15, 2002 at 5:37 am

  #158633

  Is it possible in SQL 2K to restore a single table or must you restore the whole DB. If it is possible how is it done. Thanks

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  August 15, 2002 at 5:45 am

  #434613

  You could: -

  1. Restore your DB with a new database name.

  2. Delete all the other objects in the new database except the table you want to restore.

  3. Use a DTS package containing a 'Copy SQL Server objects' task to copy the table into your original database.

  Regards,

  Andy Jones

  .