Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-08-14 : 08:06:57
|
| Ivanne writes "Sqlserver 2000, NT4I 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 !!" |
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
Posted - 2003-08-14 : 10:15:34
|
| What exactly did sp_spaceused return?Cheers,Frank |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-14 : 11:22:16
|
| Run sp_spaceused @UPDATEUSAGE = TRUE to updates the numbers.Tara |
|
|
|
|
|
|
Growth the size of a database