Changing space allocated to database

• Mark Green

  SSCrazy

  Points: 2085

  More actions

  October 5, 2006 at 7:18 am

  #192606

  How do I expand the space allocated to a database that already exists?

• AMIT GUPTA-263376

  SSCarpal Tunnel

  Points: 4244

  More actions

  October 5, 2006 at 7:39 am

  #664303

  Hi Mark,

  Open the Enterprise Manager then Select the database -> Right Click on it -> Go to the Database properties -> Open the Data file Tab -> Change the alloted size to db.

  You can also check the option of Autometic File Grow.

  Thanks & Regards

  Amit Gupta (MVP).

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  October 6, 2006 at 2:53 pm

  #664681

  Check BOL - ALTER DATABASE, SIZE MAXSIZE,  GROWTH

  and an example:

   

  ---

   alter database master modify file

    (name = master,

    size = 25MB,

    maxsize = 51MB,

    filegrowth = 25MB)

   go

   checkpoint

   go

   alter database master modify file

    (name = mastlog,

    size = 25MB,

    maxsize = 51MB,

    filegrowth = 25MB)

   go

   checkpoint

   go

  ---

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."