Home > Archive > microsoft.public.cert.mcdba > February 2004 > Failed Maintenance Job





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Failed Maintenance Job
joanna

2004-02-09, 11:25 am

I have a database maintenance plan for a 30GB database.
Part of the plan is to rebiuld indexes during weekend.
SQL server log reported the following error:

Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
[Microsoft][ODBC SQL Server Driver][SQL Server]
Could not allocate space for object '(SYSTEM table id: -
790712821)' in database 'Anthem' because the 'PRIMARY'
filegroup is full.
[Microsoft][ODBC SQL Server Driver][SQL Server]The
statement has been terminated.

How can I fix the problem? Thanks in advance.

Ray Higdon

2004-02-09, 9:25 pm

Are you out of disk space or do you have a maximum size on your
filegroup/MDF?

--
Ray Higdon MCSE, MCDBA, CCNA
---
"joanna" <anonymous@discussions.microsoft.com> wrote in message
news:d1e301c3ef26$34a7be30$a00
1280a@phx.gbl...
> I have a database maintenance plan for a 30GB database.
> Part of the plan is to rebiuld indexes during weekend.
> SQL server log reported the following error:
>
> Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
> [Microsoft][ODBC SQL Server Driver][SQL Server]
> Could not allocate space for object '(SYSTEM table id: -
> 790712821)' in database 'Anthem' because the 'PRIMARY'
> filegroup is full.
> [Microsoft][ODBC SQL Server Driver][SQL Server]The
> statement has been terminated.
>
> How can I fix the problem? Thanks in advance.
>



Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net