Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003

    Unanswered: Growth the size of a database

    Sqlserver 2000, NT4

    I want to growth a database's size from 28 Go to 30 Go.
    ("alter database" command or enterprise manager interface)

    After this change, I observe a size of 30 Go in system file (.mdf), but enterprise manager signify a size of 28 Go, as well as direct query in system tables (sysaltfiles), as well as "sp-spaceused" command.

    A calculation in this database return an error signifiying PRIMARY group file is full.

    Help !!

  2. #2
    Join Date
    Oct 2001
    Naples, FL
    Not sure about the error but for the size recognition you might need to use a dbcc updateusage command

    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts