Post reply

data space issue

  • February 16, 2010 at 5:02 pm

    #137292

    hi all..

    i have a primary file group which is default and it is unristricted..now tables are pointing to that FG.

    now issue is that drive space which has that file group is full now..i want to add that FG to new drive..but the issue is loads are coming to that FG which has to be move to other drive..can i do that?

  • February 16, 2010 at 5:46 pm

    #1119737

    You can add a secondary data file on the same filegroup to the new drive and then restrict the size of your primary data file.

  • May 17, 2012 at 12:59 am

    #1488803

    Is it possible to move existing data file to secondary file group?

    can any one say please...

  • May 19, 2012 at 6:49 am

    #1490111

    Hi,

    You can not move the datafile to different file group. Instead you can identify the biggest table and move that table to different filegroup, thus freeing up space in the current file group

    To do this u need to drop the clustered index and recreate it on diff file group

    Thanks

    Santhu

Viewing 4 posts - 1 through 3 (of 3 total)

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