I am trying to do a shrink on my data file, after large delete. It is failing and I am unable to get it working.
I am probably going to have to move to new data file. I am trying to find out if doing this will double the space to store the new file? If so, will I need to accommodate for the free space in the initial file.
I ask because the files are HUGE. 1.5 TB with 60% free space. So will I need 3TB, 2.5TB or will it just move from one file to another.