Adding Filegroup via TSQL

• Bob Bridges-173967

  SSCrazy

  Points: 2094

  More actions

  February 20, 2008 at 11:28 pm

  #186908

  I'm trying to learn to create/modify tables via TSQL rather than the GUI and am getting an error. I've tried changing everything I can think of but still get an error. Can someone please tell me what I'm doing wrong?

  Thanks,

  Bob

  The sql...

  ALTER DATABASE JeanAnnTest

  ADD FILEGROUP JA_FG

  (NAME = JeanAnn2,

  FILENAME = 'c:\MSSQL\JeanAnnTestNewFilegroup777.ndf',

  SIZE = 6MB,

  MAXSIZE = 18MB,

  FILEGROWTH = 1)

  The error...

  Msg 102, Level 15, State 1, Line 3

  Incorrect syntax near 'NAME'.

• Susantha Bathige

  Ten Centuries

  Points: 1040

  More actions

  February 21, 2008 at 1:15 am

  #780522

  ALTER DATABASE JeanAnnTest

  ADD FILEGROUP JA_FG;

  ALTER DATABASE JeanAnnTest

  ADD FILE

  (

  NAME = JeanAnn2,

  FILENAME = 'c:\MSSQL\JeanAnnTestNewFilegroup777.ndf',

  SIZE = 6MB,

  MAXSIZE = 18MB,

  FILEGROWTH = 1

  )

  TO FILEGROUP JA_FG;

  Susantha

• Bob Bridges-173967

  SSCrazy

  Points: 2094

  More actions

  February 21, 2008 at 6:14 am

  #780618

  Susantha,

  This worked.... thanks very much! (My book was not that detailed when only adding a filegroup to an existing database)

  Bob