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 |
|
mdhingra01
Posting Yak Master
179 Posts |
 Posted - 2004-05-06 : 14:41:54
|
| I am trying to run and save a dts package and I get the error:'Could not allocate space for object 'sysdtspackages' in database 'msdb'because 'PRIMARY' filegroup is full.Does anyone know how to fix this or allocate more space to fielgroup?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-06 : 14:43:06
|
| Right click on msdb database in EM, go to properties. Adjust the size of the data file. You are probably out of disk space though as the msdb database should have automatically expanded.Tara |
 |
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-05-06 : 14:54:00
|
| Currently my msdbdata.mdf (310MB) is set to automatically grow. File growth is set in MB to 1 to a maximum of unrestricted. My msdbdata.ldf (5MB) is also set to automatically grow. File growth is set in MB to 1 to a maximum of unrestricted. I checked and there is 10Gb of space left on the drive. |
|
|
|
mdhingra01
Posting Yak Master
179 Posts |
Posted - 2004-05-06 : 15:34:42
|
| Can I simply adjust the space allocated field on the data and log tabs under database properties? |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-05-06 : 15:44:25
|
| ALTER DATABASE database_nameSET SIZE = '100000000000000000'I believe that is the command you need. I wouldn't suggest running it like I have it written though.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
'PRIMARY' FILEGROUP FULL