Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question
possible duplicate of What database backup utility should I use? – RobM Aug 21 '11 at 21:58
Agree this is a duplicate. Use the built-in MSSQL backup functionality and save the off to separate storage once a day. – murisonc Aug 21 '11 at 22:22

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.

share|improve this answer
Thank you mrdenny. – Mr. Flibble Aug 21 '11 at 20:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.