How can I take backup of particular tables in SQL Server 2008 using T-SQL Script

Backup Types are dependent on SQL Server Recovery Model. Every recovery model lets you back up whole or partial SQL Server database or individual files or filegroups of the database. Table-level backup cannot be created, there is no such option. But there is a workaround for this Taking backup of SQL Server table possible in SQL Server. There are various alternative ways to backup a table in sql SQL Server BCP (BULK COPY PROGRAM) Generate Table Script with data Make a copy of table using SELECT INTO SAVE Table Data Directly in a Flat file Export Data using SSIS to any destination Here are the steps for getting sql server backup table:

• Step 1 : Right click on the database and choose Tasks –> Generate Scripts.
  
• Step 2 : Select the database from which you need to take a backup of the table.
  
• Step 3 :You will see the Table/View options on the screen while scrolling down. Select the table which you want to back up and Hit next button.