--add a new file to the databaseALTER DATABASE <YOUR_DB> ADD FILE( NAME = <TEMP_FILE_LOGICAL_NAME>, SIZE = <APPROPRIATE_SIZE_TO_AVOID_AUTOGROWTH>, FILENAME = '<TEMP_FILE_PHYSICAL_NAME>') --move data from the the existing file to the new fileDBCC SHRINKFILE('<EXISTING_FILE_LOGICAL_NAME>','EMPTYFILE')--now move it backDBCC SHRINKFILE('<TEMP_FILE_LOGICAL_NAME>','EMPTYFILE')--delete the new fileALTER DATABASE <YOUR_DB> REMOVE FILE <TEMP_FILE_LOGICAL_NAME>