Increasing DB size in SQL6.5

• darrens

  Newbie

  Points: 3

  More actions

  August 5, 2002 at 2:52 am

  #158285

  How do you increase the space allocated to a database in SQL 6.5??. I have a database using 600 meg and it's set to 650 but now I need to allocate more space to it.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738871

  More actions

  August 5, 2002 at 10:26 am

  #434036

  You increase the size of the device and then add another segment to the db.

  Forget the syntax, but EM will do this for 6.5

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones