Results 1 to 6 of 6

Thread: bcp file size

  1. #1
    Join Date
    Jan 2004
    Posts
    6

    Question Unanswered: bcp file size

    I use bcp to copy a file and the bak it generated is 966637 KB. However, when I run sp_spaceused, it shows me the following size :

    reserved data index_size unused
    ------------------ ------------------ ------------------ ------------------
    550752 KB 395272 KB 155464 KB 16 KB


    The difference doesn't make sense to me. Can anyone help pls?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What file are you using to copy with bcp? mdf?

  3. #3
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Did you bcp the data out with the -c or -n switch? This is quite understandable with the -c switch, as all the numeric and datetime values will take up much more space than in the database.

  4. #4
    Join Date
    Jan 2004
    Posts
    6
    I use the bcp to copy 1 table and the command I use is :

    bcp <table_name> out <output file> -N - S <server Name> -k -T -m 1 -e <error file>

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    So, you are trying to correlate the size of the table to the size of the resulting file using BCP? Well, it shouldn't make sense, otherwise, what's the point of having a database, heh?!

  6. #6
    Join Date
    Jan 2004
    Posts
    5
    So, you are trying to correlate the size of the table to the size of the resulting file using BCP? Well, it shouldn't make sense, otherwise, what's the point of having a database, heh?!
    Atomicity, Consistency, Isolation, and Durability... just to name a couple.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •