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?What file are you using to copy with bcp? mdf?|||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.|||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>|||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?!|||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.
没有评论:
发表评论