Help! Maintainence paln fails

Hi I am running a plan that optimizes the database, it will run for 3 hours
and when it hits a paticular file it fails.
I have changed the file growth to a new max as well as the grow by size. I
have plenty of room to grow. The following is the message I get.
Error 1105:[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for
object '(SYSTEM table id: -21614735)' in database 'itiserver' because the
'ITEMDATAI' filegroup is full.
Any suggestions are welcomed.If you need more space then don't rely on autogrow to get you there.
Manually increase the file(s) before hand. Chances are you are in this
situation because you specified in the plan to shrink the data files(removed
unused space). Turn this off and you should not have to worry about growing
the database due to reindexing each time.
--
Andrew J. Kelly SQL MVP
"robert_at_cbb" <robertatcbb@.discussions.microsoft.com> wrote in message
news:FF152B97-3108-4D98-AE4C-84F0DE6D3ADC@.microsoft.com...
> Hi I am running a plan that optimizes the database, it will run for 3
hours
> and when it hits a paticular file it fails.
> I have changed the file growth to a new max as well as the grow by size. I
> have plenty of room to grow. The following is the message I get.
>
> Error 1105:[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
for
> object '(SYSTEM table id: -21614735)' in database 'itiserver' because the
> 'ITEMDATAI' filegroup is full.
> Any suggestions are welcomed.|||Thanks, I changed the plan, and unchecked "Remove unused space from database"
Hopefully it works. Could you briefly explain what this does?
"Andrew J. Kelly" wrote:
> If you need more space then don't rely on autogrow to get you there.
> Manually increase the file(s) before hand. Chances are you are in this
> situation because you specified in the plan to shrink the data files(removed
> unused space). Turn this off and you should not have to worry about growing
> the database due to reindexing each time.
> --
> Andrew J. Kelly SQL MVP
>
> "robert_at_cbb" <robertatcbb@.discussions.microsoft.com> wrote in message
> news:FF152B97-3108-4D98-AE4C-84F0DE6D3ADC@.microsoft.com...
> > Hi I am running a plan that optimizes the database, it will run for 3
> hours
> > and when it hits a paticular file it fails.
> >
> > I have changed the file growth to a new max as well as the grow by size. I
> > have plenty of room to grow. The following is the message I get.
> >
> >
> > Error 1105:[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
> > [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space
> for
> > object '(SYSTEM table id: -21614735)' in database 'itiserver' because the
> > 'ITEMDATAI' filegroup is full.
> >
> > Any suggestions are welcomed.
>
>|||That checkbox will issue a DBCC SHRINKDATABASE which causes the data and log
files to shrink. But in the process it must move the data pages that are at
the end of the file to the beginning since it shrinks from the end. This
movement of pages will fragment the indexes and tables all over again. Then
the next time the maintenance plan goes to "Optimize" (reindex) the indexes
it will force the db to grow again since it requires about 1.2 times the
size of the table in free space to happen properly.
--
Andrew J. Kelly SQL MVP
"robert_at_cbb" <robertatcbb@.discussions.microsoft.com> wrote in message
news:46D23E6F-F0C8-4DA9-9961-1EA3659FDEAC@.microsoft.com...
> Thanks, I changed the plan, and unchecked "Remove unused space from
database"
> Hopefully it works. Could you briefly explain what this does?
> "Andrew J. Kelly" wrote:
> > If you need more space then don't rely on autogrow to get you there.
> > Manually increase the file(s) before hand. Chances are you are in this
> > situation because you specified in the plan to shrink the data
files(removed
> > unused space). Turn this off and you should not have to worry about
growing
> > the database due to reindexing each time.
> >
> > --
> > Andrew J. Kelly SQL MVP
> >
> >
> > "robert_at_cbb" <robertatcbb@.discussions.microsoft.com> wrote in message
> > news:FF152B97-3108-4D98-AE4C-84F0DE6D3ADC@.microsoft.com...
> > > Hi I am running a plan that optimizes the database, it will run for 3
> > hours
> > > and when it hits a paticular file it fails.
> > >
> > > I have changed the file growth to a new max as well as the grow by
size. I
> > > have plenty of room to grow. The following is the message I get.
> > >
> > >
> > > Error 1105:[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1105:
> > > [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate
space
> > for
> > > object '(SYSTEM table id: -21614735)' in database 'itiserver' because
the
> > > 'ITEMDATAI' filegroup is full.
> > >
> > > Any suggestions are welcomed.
> >
> >
> >