2

Is it possible to backup entire sql server database into one unique file using bcp?

Improve this question
4
  • 3
    Sure, as long as your database has only one table. In practical terms, the answer is no. Commented Nov 12, 2013 at 17:53
  • @acfrancis My database has multiple tables. so the answer is 'no' as i understand. Commented Nov 12, 2013 at 17:55
  • 2
    Correct. Why would you want to do that anyway? A proper backup is much better in most cases. Commented Nov 12, 2013 at 17:57
  • see stackoverflow.com/q/19934411/10245 Commented Oct 24, 2014 at 9:14

1 Answer 1

Reset to default
2

SQL Server BCP does not support this.

http://technet.microsoft.com/en-us/library/ms162802.aspx

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.