November 22, 2011 at 10:11 am
I'm going to run DBCC Shrinkfile to migrate data out of a huge file into 2 new files. After the data is migrated, do I need to drop the old file? If yes, could you please explain the procedure?
DBCC SHRINKFILE ('<logical file name>', EMPTYFILE )
November 23, 2011 at 12:20 pm
sunny.tjk (11/22/2011)
I'm going to run DBCC Shrinkfile to migrate data out of a huge file into 2 new files. After the data is migrated, do I need to drop the old file? If yes, could you please explain the procedure?DBCC SHRINKFILE ('<logical file name>', EMPTYFILE )
Once data is migrated you can drop the empty data file using Alter Database Remove File command.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply