Filegroup is full

Hi.
I've a msde database and I'm getting the following error every minute
Error 1105, Severity: 17, ErrState: 2
Could not allocate space for object 'ProductSettings' in database
'epo_Srv-ms-avd' because the 'Primary' filegroup is full
I've cleanup the database but the error keeps on.
I need urgent help!!!
Thank you very much
Hi Eduardo,
How big is the database? Any chance it's up to 2G (ie the limit)?
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Eduardo Crespo" <crespo_santamaria@.NOSPAMhotmail.com> wrote in message
news:OoFIRcmuEHA.1992@.TK2MSFTNGP10.phx.gbl...
> Hi.
> I've a msde database and I'm getting the following error every minute
> Error 1105, Severity: 17, ErrState: 2
> Could not allocate space for object 'ProductSettings' in database
> 'epo_Srv-ms-avd' because the 'Primary' filegroup is full
> I've cleanup the database but the error keeps on.
> I need urgent help!!!
> Thank you very much
>
>
|||hi Eduardo,
"Eduardo Crespo" <crespo_santamaria@.NOSPAMhotmail.com> ha scritto nel
messaggio news:OoFIRcmuEHA.1992@.TK2MSFTNGP10.phx.gbl
> Hi.
> I've a msde database and I'm getting the following error every minute
> Error 1105, Severity: 17, ErrState: 2
> Could not allocate space for object 'ProductSettings' in database
> 'epo_Srv-ms-avd' because the 'Primary' filegroup is full
> I've cleanup the database but the error keeps on.
> I need urgent help!!!
> Thank you very much
in addition to Greg's answer, try executing
EXEC sp_helpdb 'your_db_name'
to see, in the 2nd resultset, if the datafile has limited file maxsize
option set or it can growth till 2gb limit...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you very much. Database size is 2 GB
"Eduardo Crespo" <crespo_santamaria@.NOSPAMhotmail.com> escribi en el
mensaje news:OoFIRcmuEHA.1992@.TK2MSFTNGP10.phx.gbl...
> Hi.
> I've a msde database and I'm getting the following error every minute
> Error 1105, Severity: 17, ErrState: 2
> Could not allocate space for object 'ProductSettings' in database
> 'epo_Srv-ms-avd' because the 'Primary' filegroup is full
> I've cleanup the database but the error keeps on.
> I need urgent help!!!
> Thank you very much
>
>