SQL Server Backup

• sstecher

  Ten Centuries

  Points: 1057

  More actions

  March 12, 2004 at 9:47 am

  #359296

   Hey guys,

  I'm kinda new to SQL Server 2000 and want to know on a database backup, how do I only do a backup/restore on tables.  I don't want to do a full backup I just want the table data.  All the help is appreciated.

  Thanks

• Justin-14543

  SSCrazy

  Points: 2017

  More actions

  March 13, 2004 at 1:07 pm

  #498670

  The simplest way is to DTS the table to some other format like text file or excel file depending on the size.

  Give me a fish, you feed me for a day! Teach me to fish, you feed me for a life time.