Post reply

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

  • September 4, 2012 at 7:26 am

    #281069

    Hi everyone,

    I am new to databses when i creating new datasbe using tsql commands i struct with this error can anyone help me to get rid of this issue. below is the code thanks

    create database fuel

    on primary

    (

    name='transaction',

    filename='C:\Users\Vinay.Varala\Documents\final_df\trans.mdf',

    size= 20,

    maxsize=200,

    filegrowth=10mb

    ),

    filegroup delivery

    (

    name='delivery_df',

    filename ='C:\Users\Vinay.Varala\Documents\final_df\deliv.ndf'

    )

    log on

    (

    name = 'log_data',

    filename='C:\Users\Vinay.Varala\Documents\final_df\log.ldf',

    size=10,

    maxsize=200,

    filegrowth =auto

    )

  • September 4, 2012 at 8:09 am

    #1533281

    Auto is not an option for filegrowth, specify the growth increment you want.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 4, 2012 at 9:11 am

    #1533346

    CREATE DATABASE (Transact-SQL)

    FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ]

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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