Moving Tables to Different Filegroups

• aruram

  SSCrazy

  Points: 2379

  More actions

  September 18, 2007 at 3:43 pm

  #76781

  We are currently facing a space issue and the drive that the primary data files reside on is almost full.

  Is there a way to move some of the larger tables in the DB to other drives on the server?

  Thanks

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  September 18, 2007 at 3:57 pm

  #734425

  Of course.

  Check out this post.

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=399995#bm400018

  Reference books online for filegroups.