Post reply

Database size

  • October 29, 2007 at 11:11 am

    #199513

    I found a db on the production SQL 2005 box that is set to auto grow 1mb. I would like to change the reserved space and also that way it auto grows.

  • October 29, 2007 at 12:22 pm

    #746359

    alter database <YourDatabaseName>

    modify file(name='<YourDatabaseName>',size=<MinimumSizeWanted in MB>,filegrowth=<Growth in MB or num% for percent growth>)

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

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