Page allocation error

Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages
available in filegroup PRIMARY. Space can be created by dropping objects,
adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile
is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Sometimes autogrow doesn't catch up with the space requirements, resulting in this error message. I suggest
you pre-allocate storage.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> Hi all,
> There a quite strange error i am getting :
> "Could not allocate new page for database 'rough'. There are no more pages
> available in filegroup PRIMARY. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> This database has unrestricted filegrowth, the current size of the datafile
> is 4.6GB and there is 9 GB space free on the hard disk.
> The recovery model is full logged.
> sql server 2k with sp3a.
> any thoughts?
> harshal.
>|||yeah for the same reason i tried to increase the size of the file from the
enterprise manager it still gave me the same error.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Sometimes autogrow doesn't catch up with the space requirements, resulting
in this error message. I suggest
> you pre-allocate storage.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > Hi all,
> > There a quite strange error i am getting :
> > "Could not allocate new page for database 'rough'. There are no more
pages
> > available in filegroup PRIMARY. Space can be created by dropping
objects,
> > adding additional files, or allowing file growth."
> >
> > This database has unrestricted filegrowth, the current size of the
datafile
> > is 4.6GB and there is 9 GB space free on the hard disk.
> >
> > The recovery model is full logged.
> > sql server 2k with sp3a.
> >
> > any thoughts?
> >
> > harshal.
> >
> >
>|||Seems to be a problem at the OS level, if SQL Server cannot allocate space even though space exists on the
hard drive. A couple of things to check is if you have disk quotas or compression.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> yeah for the same reason i tried to increase the size of the file from the
> enterprise manager it still gave me the same error.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > Sometimes autogrow doesn't catch up with the space requirements, resulting
> in this error message. I suggest
> > you pre-allocate storage.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > Hi all,
> > > There a quite strange error i am getting :
> > > "Could not allocate new page for database 'rough'. There are no more
> pages
> > > available in filegroup PRIMARY. Space can be created by dropping
> objects,
> > > adding additional files, or allowing file growth."
> > >
> > > This database has unrestricted filegrowth, the current size of the
> datafile
> > > is 4.6GB and there is 9 GB space free on the hard disk.
> > >
> > > The recovery model is full logged.
> > > sql server 2k with sp3a.
> > >
> > > any thoughts?
> > >
> > > harshal.
> > >
> > >
> >
> >
>|||no there is no compression done on the disk and the funny thing is that if i
delete some thing on the disk then it allows me to allocate the space for
that database, but even if i dont delete anything and try to increase the
space on other database there is no problem.
what else do i be looking for?
Thanks and Regards,
Harshal.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujLfGjOOEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Seems to be a problem at the OS level, if SQL Server cannot allocate space
even though space exists on the
> hard drive. A couple of things to check is if you have disk quotas or
compression.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> > yeah for the same reason i tried to increase the size of the file from
the
> > enterprise manager it still gave me the same error.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > > Sometimes autogrow doesn't catch up with the space requirements,
resulting
> > in this error message. I suggest
> > > you pre-allocate storage.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> > news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > > Hi all,
> > > > There a quite strange error i am getting :
> > > > "Could not allocate new page for database 'rough'. There are no more
> > pages
> > > > available in filegroup PRIMARY. Space can be created by dropping
> > objects,
> > > > adding additional files, or allowing file growth."
> > > >
> > > > This database has unrestricted filegrowth, the current size of the
> > datafile
> > > > is 4.6GB and there is 9 GB space free on the hard disk.
> > > >
> > > > The recovery model is full logged.
> > > > sql server 2k with sp3a.
> > > >
> > > > any thoughts?
> > > >
> > > > harshal.
> > > >
> > > >
> > >
> > >
> >
> >
>