Post reply

FileGroups

  • April 26, 2007 at 3:12 am

    #116933

    Hi Guys,

    Does anyone have any idea how I can consolidate filegroups?

    Regards

    IC

  • April 26, 2007 at 11:39 am

    #702720

    Use DBCC shrinkfile with the EMPTYFILE option to migrate all data from the specified filegroup.

    This will migrates all data from the specified file to other files in the same filegroup. The SQL Server 2005 Database Engine does not allow for data to be placed on the file used with the EMPTYFILE option. This option enables the file to be dropped by using alter database.

    Just in case.....test with a temporary database first.

    Eric

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

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