Combine MDF and NDF Files to One File

  • Hello

    I have a database that is broken into three files. One is the log, the other two are a mdf file and ndf file. The mdf is in the primary file group and the ndf is in another group group. Is there any way to put the two files together into one mdf file? Oddly, the ndf is set as the default file group. The ndf is 59656mb where as the mdf is 6mb. I am not concerned about disk space and both files are in the same folder and on the same drives. I see no reason to have this database split as it is, since disk space is not an issue. Thanks

    John

  • Well you cant combine the 2 files but you can move the objects from one file to another and then remove the empty file.

    "Keep Trying"

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply