How to divide 40GB database into 10 4GB Datafiles

• AlexSQLForums

  SSChampion

  Points: 14277

  More actions

  January 29, 2008 at 4:02 pm

  #181420

  I have a production database that's 43 GB.

  There are 6 tables and one table is about 39GB and there is only one datafile and it's 40GB and a tran log which is 3 GB.

  I would like to divide it into 10 datafiles so that I could backup faster.

  What would be the best way to do this?

  Thanks in advance

  Alex S

• Donna Hawley-340938

  SSC Enthusiast

  Points: 103

  More actions

  January 29, 2008 at 4:35 pm

  #773081

  I suggest that you create a filegroup with 10 files in it. Then move your big table to that filegroup. This will leave your primary filegroup oversized, so you may want to shrink it.

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  January 29, 2008 at 9:41 pm

  #773111

  It is rude to post the same question multiple times:

  http://www.sqlservercentral.com/Forums/Topic449121-5-1.aspx

• Ahmad Osama

  SSCertifiable

  Points: 7676

  More actions

  January 29, 2008 at 11:34 pm

  #773128

  Hi,

  Do u have Raid implemented.

  Regards,

  Ahmad

  Regards,
  [font="Verdana"]Sqlfrenzy[/font]