DBA328 (10/21/2012)
one question about EMPTYFILE paramters:If i have 4 data files on one filegroup, then i use DBCC SHRINKFILE with emptyfile paramter to empty the first data file, which file these data on file1 will be moved to?
The obvious reason for emptying a file is so that you can delete it. You cannot remove the primary file from the primary file group.
When emptying a file the data will be dispersed to other files in the same file group that have available space.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉