Could not allocate space for object 'xxx' in database 'abc' becaus

Error 1105 Could not allocate space for object 'xxx' in database 'abc'
because the 'PRIMARY' filegroup is full..
Hello,
I hope somebody can help me with this issue:
The message above appears on a db that has separately located data and log
files. the host server itself has ample disk space,
but the db is not set to autogrow but instead has
been sized appropriately and about half of the data is still free (several
hundred mb). the db options are all set appropriately.
I have dumped the tran log and rebooted server.
I perform a select * into x from y (where y has 1 row of data) and I get the
above error, yet if I create table x and then insert
20 rows of data I don't get an error.
I am missing something obvious?have you checked if there is any limit to the auto-growth of the data files
configured?
Paulo Ferreira
http://www.info2k.pt
SQL Server DBA Experts
"sysbox27" wrote:
> Error 1105 Could not allocate space for object 'xxx' in database 'abc'
> because the 'PRIMARY' filegroup is full..
> Hello,
> I hope somebody can help me with this issue:
> The message above appears on a db that has separately located data and log
> files. the host server itself has ample disk space,
> but the db is not set to autogrow but instead has
> been sized appropriately and about half of the data is still free (several
> hundred mb). the db options are all set appropriately.
> I have dumped the tran log and rebooted server.
> I perform a select * into x from y (where y has 1 row of data) and I get the
> above error, yet if I create table x and then insert
> 20 rows of data I don't get an error.
> I am missing something obvious?
>|||Hi Paulo,
FILEGROWTH=0%. I don't want it to autogrow but in current config there is
still plenty of space for growth.
Rgds.
"Paulo Ferreira" wrote:
> have you checked if there is any limit to the auto-growth of the data files
> configured?
>
> --
> Paulo Ferreira
> http://www.info2k.pt
> SQL Server DBA Experts
>
>
> "sysbox27" wrote:
> > Error 1105 Could not allocate space for object 'xxx' in database 'abc'
> > because the 'PRIMARY' filegroup is full..
> >
> > Hello,
> > I hope somebody can help me with this issue:
> > The message above appears on a db that has separately located data and log
> > files. the host server itself has ample disk space,
> > but the db is not set to autogrow but instead has
> > been sized appropriately and about half of the data is still free (several
> > hundred mb). the db options are all set appropriately.
> > I have dumped the tran log and rebooted server.
> >
> > I perform a select * into x from y (where y has 1 row of data) and I get the
> > above error, yet if I create table x and then insert
> > 20 rows of data I don't get an error.
> >
> > I am missing something obvious?
> >|||"sysbox27" <sysbox27@.discussions.microsoft.com> wrote in message
news:A51F188A-BE9E-44F2-B8D9-AFC6F3105187@.microsoft.com...
> Error 1105 Could not allocate space for object 'xxx' in database 'abc'
> because the 'PRIMARY' filegroup is full..
> Hello,
> I hope somebody can help me with this issue:
> The message above appears on a db that has separately located data and log
> files. the host server itself has ample disk space,
> but the db is not set to autogrow but instead has
> been sized appropriately and about half of the data is still free (several
> hundred mb). the db options are all set appropriately.
> I have dumped the tran log and rebooted server.
> I perform a select * into x from y (where y has 1 row of data) and I get
> the
> above error, yet if I create table x and then insert
> 20 rows of data I don't get an error.
> I am missing something obvious?
>
DBCC updatestats
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||and how many filegroups do you have?
all tables are on the primary filegroup?
what is the sql server version? do you have the last sp applied?
what is the size of the database?
what are the limitations and space allocated on the data and log files?
--
Paulo Ferreira
http://www.info2k.pt
SQL Server DBA Experts
"sysbox27" wrote:
> Hi Paulo,
> FILEGROWTH=0%. I don't want it to autogrow but in current config there is
> still plenty of space for growth.
> Rgds.
>
> "Paulo Ferreira" wrote:
> > have you checked if there is any limit to the auto-growth of the data files
> > configured?
> >
> >
> > --
> > Paulo Ferreira
> >
> > http://www.info2k.pt
> > SQL Server DBA Experts
> >
> >
> >
> >
> > "sysbox27" wrote:
> >
> > > Error 1105 Could not allocate space for object 'xxx' in database 'abc'
> > > because the 'PRIMARY' filegroup is full..
> > >
> > > Hello,
> > > I hope somebody can help me with this issue:
> > > The message above appears on a db that has separately located data and log
> > > files. the host server itself has ample disk space,
> > > but the db is not set to autogrow but instead has
> > > been sized appropriately and about half of the data is still free (several
> > > hundred mb). the db options are all set appropriately.
> > > I have dumped the tran log and rebooted server.
> > >
> > > I perform a select * into x from y (where y has 1 row of data) and I get the
> > > above error, yet if I create table x and then insert
> > > 20 rows of data I don't get an error.
> > >
> > > I am missing something obvious?
> > >