Invalid usage of the option filename

• SQL Galaxy

  One Orange Chip

  Points: 29420

  More actions

  March 26, 2011 at 6:31 am

  #96190

  Hi,

  1. alter database DBMonitor add filegroup DBINDEX01

  running successfully

  2. alter database DBMonitor add file (name = BribsIndex01

  filename ='D:\Program Files\Microsoft SQL Server\MSSQL\Data\BribsIndex01.ndf',

  Size=8MB,

  maxsize=unlimited,

  filegrowth=10MB)

  To Filegroup DBINDEX01

  Server: Msg 153, Level 15, State 1, Line 2

  Invalid usage of the option filename in the CREATE/ALTER DATABASE statement.

  please give me solution, what is the wrong in statement?

  Thanks

  ananda

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  March 26, 2011 at 11:23 am

  #1303963

  Comma (,) is missing after this

  name = BribsIndex01

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga