A utility to backup single tables on MSSQL?

Are there any Windows utilities that allow you back up single MSSQL tables? Having a lot or trouble finding any. I hear sqlbackupandftp is good, but as far as I can see, it doesn't back up single tables.

Solution 1:

There is nothing to backup a single table. You can BCP tables out using the OUT syntax.

bcp YourDatabase.Owner.Table OUT d:\Yourfile.ext 

This will dump the contents of a single table to an output file.

If you were to dump two tables from the database they would not be transactionly consistent with each other. Because of this, this would not be a good way to backup your database.