• 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" 😉