I have run into an issue I can not figure out. I am running a 2014 sql express server that is connected to and importing data from a 2008 R2 sql server. Each server is Hosted within the same Virtual Machine host using the same data storage but on individual VMs. When trying an import the from the express machine the script runs well but hangs because of some type of temp disk space utilization that that fills the drive with over 40GB. On reboot the disk space returns to normal. The script is pulling only about 6000 records from the other data base and when complete the dtabase file is less than 50MB.
We copied the data from the remote server and placed it on the 2014 express server changed the script to look remotely and the import happened as it should.
My questions are why and how does the fail happen? Why would a large temp file of some type be written when importing between VMs. How do I over come this?
I will provide any other information you may need and thank you for your help.