hmm interesting ...it depends from your storage that you have and sure from how many records that you have in your table ... example you will wait for a time when you start to copy over millions records sure that the data file and the log file will grow and it can be with GB...
Describe more about your problem and what you want to do, in details, also post some info about your storage (how many MB or GB you have free)?
============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]