File transfering between filegroups

• pavan-178969

  SSC-Addicted

  Points: 452

  More actions

  January 30, 2006 at 10:45 am

  #152717

  Hi,

  I have 2 files in primary filegroup both are having data in it.

  I have created a new filegroup  and want to shift one file (non .mdf) from the primary filegroup to the new filegroup, what are the ways to do it and which one is the most efficient?

• February 2, 2006 at 8:00 am

  This was removed by the editor as SPAM

• ARUL-285958

  Ten Centuries

  Points: 1081

  More actions

  February 5, 2006 at 10:09 pm

  #618896

  Take that DB offline.

  Move the files to different location.

  Detach and then attach using sp pointing to the file location

  ---

  Get busy living ....or get busy dying....