• DBA328 (10/19/2012)


    DBCC shirinkfile may not move data to other files. you can virtually move the data from the table to a different filegroup by creating a clustered index and placing it wherever you want

    DBCC SHRINKFILE won't move data across filegroups, which is what i believe you're referring to, for that you will need to move the actual index\object.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉