Backup and Restore of a single table

• control

  SSCommitted

  Points: 1630

  More actions

  January 3, 2003 at 12:59 pm

  #159048

  In SQL Server 6.5 version, it is possible to backup and load a single table from the backup of full dump file.

  Do any DBA knows how to backup and load a single table?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 5, 2003 at 6:09 pm

  #445586

  No you can only restore the complete device to another location then export the data via bcp or other method to import into the original.