Error 1105

Following is the error message that we get when we try to
do some process:
Error No:1105
========== Could not allocate space for object '(System table id:3)'
in database 'database name' because primary filegroup is
full.
sometimes we do get error like the one following:
Could not allocate new page for database 'database
name'.There are no more pages available in filegroup
Primary.
Space can be created by dropping objects,adding additional
files , or allowing filegrowth.
How do I handle this programatically.I'm not sure exactly what you mean by 'handle programmatically' but, as the
error message states, you can set your data file to autogrow. This will
automatically expand the data file as needed, assuming you have available
disk space. However, for performance reasons, it is better to anticipate
space requirements and size the file accordingly.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||We are using JDBC to connect SQL server.
JDBC driver provided in SQL server.
We create database from JDBC and specify initial size
while creating database.
Using JDBC driver autogrow option fails. All transaction
fails with auto grow option.
This is the reason we specify initial value.
When the more record are added to tables and grows to
size specified it works fine. After exceeding the
specified size or just before that
it gives Error 1105
Thanks in advance
Lakshmi.
>--Original Message--
>I'm not sure exactly what you mean by 'handle
programmatically' but, as the
>error message states, you can set your data file to
autogrow. This will
>automatically expand the data file as needed, assuming
you have available
>disk space. However, for performance reasons, it is
better to anticipate
>space requirements and size the file accordingly.
>--
>Hope this helps.
>Dan Guzman
>SQL Server MVP
>"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
message
>news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
>> Following is the error message that we get when we try
to
>> do some process:
>> Error No:1105
>> ==========>> Could not allocate space for object '(System table
id:3)'
>> in database 'database name' because primary filegroup is
>> full.
>> sometimes we do get error like the one following:
>> Could not allocate new page for database 'database
>> name'.There are no more pages available in filegroup
>> Primary.
>> Space can be created by dropping objects,adding
additional
>> files , or allowing filegrowth.
>> How do I handle this programatically.
>
>.
>|||You might try to use the
alter database alte file
command... It allows you to change file growth paramters for the database
programmatically.
"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> Following is the error message that we get when we try to
> do some process:
> Error No:1105
> ==========> Could not allocate space for object '(System table id:3)'
> in database 'database name' because primary filegroup is
> full.
> sometimes we do get error like the one following:
> Could not allocate new page for database 'database
> name'.There are no more pages available in filegroup
> Primary.
> Space can be created by dropping objects,adding additional
> files , or allowing filegrowth.
> How do I handle this programatically.
>|||In addition to the initial size, you can specify the growth increment and
max size so that the file can grow automatically if needed. You can specify
this in your CREATE DATABASE statement or after database creation with ALTER
DATABASE as Wayne suggested.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"lakshmi" <anonymous@.discussions.microsoft.com> wrote in message
news:1882f01c42095$f8e54f10$a601280a@.phx.gbl...
> We are using JDBC to connect SQL server.
> JDBC driver provided in SQL server.
> We create database from JDBC and specify initial size
> while creating database.
> Using JDBC driver autogrow option fails. All transaction
> fails with auto grow option.
> This is the reason we specify initial value.
> When the more record are added to tables and grows to
> size specified it works fine. After exceeding the
> specified size or just before that
> it gives Error 1105
> Thanks in advance
> Lakshmi.
> >--Original Message--
> >I'm not sure exactly what you mean by 'handle
> programmatically' but, as the
> >error message states, you can set your data file to
> autogrow. This will
> >automatically expand the data file as needed, assuming
> you have available
> >disk space. However, for performance reasons, it is
> better to anticipate
> >space requirements and size the file accordingly.
> >
> >--
> >Hope this helps.
> >
> >Dan Guzman
> >SQL Server MVP
> >
> >"Lakshmi" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:16c9101c4208d$d56c5220$a001280a@.phx.gbl...
> >> Following is the error message that we get when we try
> to
> >> do some process:
> >>
> >> Error No:1105
> >> ==========> >> Could not allocate space for object '(System table
> id:3)'
> >> in database 'database name' because primary filegroup is
> >> full.
> >> sometimes we do get error like the one following:
> >> Could not allocate new page for database 'database
> >> name'.There are no more pages available in filegroup
> >> Primary.
> >> Space can be created by dropping objects,adding
> additional
> >> files , or allowing filegrowth.
> >>
> >> How do I handle this programatically.
> >>
> >
> >
> >.
> >