Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

1 Answer 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.

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

Your Answer

 
discard

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.