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 |
|
Vivaldi
Constraint Violating Yak Guru
298 Posts |
 Posted - 2003-07-17 : 12:00:59
|
| Okay,I have read about this and everyone says the disk is out of spaceor the growth is locked.In the "properties" of a sql server table, it says there are several megs available. (says 7) so I cannot even create a view?>>Could not allocate space for object '(SYSTEM table id: 3)' in database 'C_Test' >>because the 'PRIMARY' filegroup is full.Does the "auto shrink" feature do anything?could I get rid of any of the db's that come with sql server (pubs,northwind). I am pretty sure they are only useful for testng.Any other suggestions, this is a new area in administration I haven't had to deal with.Thanks.________________________________________________(Beer + Beer + Beer + Beer + Beer + Martini w/French Vodka + Beer + Beer + Beer) = Sick |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-17 : 12:46:08
|
| Run this in Query Analyzer:BACKUP LOG C_Test WITH NO_LOGIf you need to reclaim the disk space, then run DBCC SHRINKDB and/or DBCC SHRINKFILE.Also, you should the recovery model of this database. Since it is a test database, it should be set to SIMPLE. You can find the recovery model in EM by going to the database and then going to its properties, then to options.Tara |
 |
|
|
|
|
|
Filegroup is full