Adding Filegroups and creating tables on that filegroup

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  December 16, 2005 at 7:17 am

  #92434

  Hi,

  I need to add secondary file group to each database and create a table assigned to that filegroup in each database. I am looking for commands to do this so that I could write an application to do this automatically instead of going to each database and doing it. Please let me know.

  Thanks,

  Sridhar.

• ramses2nd

  Hall of Fame

  Points: 3720

  More actions

  December 16, 2005 at 7:47 am

  #610056

  Here is a sample of the code I used to create a new File Group, a new file, and then add a table to that File Group.

  ALTER DATABASE [DELTA2] ADD FILEGROUP [SECONDARY]

  GO

  ALTER DATABASE [DELTA2] ADD FILE(NAME = N'FILE_2',

  FILENAME = N'C:\FILE_2_Data.NDF' ,

  SIZE = 1, FILEGROWTH = 10%)

  TO FILEGROUP [SECONDARY]

  GO

  CREATE TABLE TBL_NEW

   ( FIELD_1 INTEGER NOT NULL,

   FIELD_2 VARCHAR(255) NULL) ON [SECONDARY]

  GO

• Sridhar-137443

  Hall of Fame

  Points: 3762

  More actions

  December 16, 2005 at 8:36 am

  #610086

  Thanks!