'PRIMARY' filegroup is full (yet another)

Hello,
I am getting this error on the database msdb when trying to update a DTS
package.
When I look at msdb, it is set to automatically grow and autoshrink is off.
I changed the auto-grow on the MDF file to 10% but that didn't help.
I then tried changing the space allocated - on the Data Files tab in the
Properties menu after right-clicking the database in Enterprise Manager. As
soon as I hit "OK", the size changes back to the original (too small) value
and nothing has changed. What else could be wrong, and why can't I change
the size'
Thanks
LesTry changing the size using ALTER DATABASE and see if you get any error mess
age. Also see if you
have autoshrink turned on for the database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
> Hello,
> I am getting this error on the database msdb when trying to update a DTS
> package.
> When I look at msdb, it is set to automatically grow and autoshrink is off
.
> I changed the auto-grow on the MDF file to 10% but that didn't help.
> I then tried changing the space allocated - on the Data Files tab in the
> Properties menu after right-clicking the database in Enterprise Manager.
As
> soon as I hit "OK", the size changes back to the original (too small) valu
e
> and nothing has changed. What else could be wrong, and why can't I change
> the size'
> Thanks
> Les|||With an 'is it plugged in question' (because all your factors were within
SS)--is there enough room on the disk?
--
Joseph R.P. Maloney, CSP,CCP,CDP
"Tibor Karaszi" wrote:

> Try changing the size using ALTER DATABASE and see if you get any error me
ssage. Also see if you
> have autoshrink turned on for the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
> news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
>|||Hello,
I used the ALTER DATABASE command and it increased the PHYSICAL size of the
file on disk. However it had no effect on the "Space Allocated (MS)" figure
and the database still refuses to expand. Autoshrink os OFF and always has
been.
I tried increasing the MAXSIZE - this also had no effect. This is extremely
frustrating - the server is basically ignoring my instructions. Could it be
a security issue? (although I am getting no warning or error messages). The
owner of the database is sa.
There is 50GB of space left on the disk - no problem there.
We are now stuck in a situation where we cannot modify our DTS packages.
Any help appreciated.
Les
"Tibor Karaszi" wrote:

> Try changing the size using ALTER DATABASE and see if you get any error me
ssage. Also see if you
> have autoshrink turned on for the database.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Les Russell" <LesRussell@.discussions.microsoft.com> wrote in message
> news:4D994768-4737-4CA9-9817-BFE42C083317@.microsoft.com...
>|||I seemed to have got this to work by creating a second file to the PRIMARY
filegroup for the msdb database. However I would still be interested in any
theories as to why I couldn't get the single file to work.
I should mention we are having software RAID problems on this server - I
don't think they are a factor because I am getting no related error messages
.
Les
"Les Russell" wrote:
[vbcol=seagreen]
> Hello,
> I used the ALTER DATABASE command and it increased the PHYSICAL size of th
e
> file on disk. However it had no effect on the "Space Allocated (MS)" figu
re
> and the database still refuses to expand. Autoshrink os OFF and always ha
s
> been.
> I tried increasing the MAXSIZE - this also had no effect. This is extreme
ly
> frustrating - the server is basically ignoring my instructions. Could it
be
> a security issue? (although I am getting no warning or error messages). T
he
> owner of the database is sa.
> There is 50GB of space left on the disk - no problem there.
> We are now stuck in a situation where we cannot modify our DTS packages.
> Any help appreciated.
> Les
> "Tibor Karaszi" wrote:
>