Home / server / Questions / 303566
In Process
Mr. Flibble
Asked: 2011-08-22 11:34:32 +0800 CST

A utility to backup single tables on MSSQL?

  • 772

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.

windows sql-server database-backup

1 Answers

  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.

    • 1