We have a SQL 2000 server over here on which we have a large database of 200 GB having 2 datafiles , both in Primarry file group. Datafiles are IT1 (located oin E: drive) nd IT2(located on F: drive). IT1 size is 110 GB & IT2 is newly created data file with 89GB size.
Now we are trying to move all the data from IT1 to IT2 using
DBCC Shrinkfile('IT1',EMPTYFILE) command.
It's completed successfully just in milli secs. that is not the expected time to finish bcoz IT1 is so large . After completition, both files are still of same size means no data movement from IT1 to IT2. What can be reason that command completed prematurely?
For IT2, we have unrestricted growth by 64MB.. please get back to me ASAP