Often time you will be requested to run SQL scripts to update or remove data in specific tables.  While the preferred backup method would be the entire database, you can also choose to only backup the individual table.

To backup an individual table

Log in to the SQL server and open SQL server Management Studio.  (Start >> Programs >> Microsoft SQL Server  >>  SQL Management Studio). Use the SQL statement below to backup an individual table.

Select * into XXXXXbak
from XXXXX
You will need to replace the 'xxxxx' with the actual table name you are wanting to back up.

Once you have verified the change to the data has been successful, you can remove the table from the database by running the SQL script below.

Drop XXXXXbak