EBS EBS - 10 days ago 6
SQL Question

Backup a single table with its data from a database in sql server 2008

I want to get a backup of a single table with its data from a database in SQL Server using a script.

How can I do that?

Answer

There are many ways you can take back of table.
Look into this link :http://www.sqlserver-training.com/how-to-backup-sql-table/-

  1. BCP (BULK COPY PROGRAM)
  2. Generate Table Script with data
  3. Make a copy of table using SELECT INTO
  4. SAVE Table Data Directly in a Flat file
  5. Export Data using SSIS to any destination
Comments