Post reply

Breaking up a huge data file

  • June 22, 2007 at 10:02 am

    #68846

    We have huge data file of size 118GB in one database. can we make that into 4 small sized units of 30GB each?

  • June 22, 2007 at 10:15 am

    #714638

    Sort of... Add filegroups with the other data files to the database. Then you have a couple of options. To move the physical data, you can rebuild the clustered index onto one of the other filegroups. You can also rebuild nonclustered indexes onto other filegroups.

    For best performance it's usually good to split your clustered indexes (data) and nonclustered indexes onto separate filegroups on separate drives.

  • June 22, 2007 at 10:15 am

    #714637

    Yes. Add new filegroups and files to your database and i think you should be able to move some objects around

    Everything you can imagine is real.

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

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