On my C: Drive I have 128GB mirrored drive for the OS (about 90 GB free) and a 3 TB RAID-5 E: Drive for all my SQL Data. The db that I am copying from the old server has several tables in it and one of them is 129 GB with over 5 million records.
Long story short, I cannot just backup the old DB and move it because a bunch of data has to be transformed so I create a view on the old server that has the data modifications in it and linked the servers and use a simple insert into query to copy the view into the new table on the new server.
It appears that when I run insert into statement on the new server it does not just dump the data into the db on my RAID-5 drive. It is copying the data into the tempdb on my rather small C: Drive first. Since I am tring to copy 129 and my drive only has about 90 GB free, it fails.
Is there a way to have the Insert Into statement just dump the data directly into the end table or will I have to move the TempDB to the RAID-5 drive?
Long story short, I cannot just backup the old DB and move it because a bunch of data has to be transformed so I create a view on the old server that has the data modifications in it and linked the servers and use a simple insert into query to copy the view into the new table on the new server.
It appears that when I run insert into statement on the new server it does not just dump the data into the db on my RAID-5 drive. It is copying the data into the tempdb on my rather small C: Drive first. Since I am tring to copy 129 and my drive only has about 90 GB free, it fails.
Is there a way to have the Insert Into statement just dump the data directly into the end table or will I have to move the TempDB to the RAID-5 drive?
