Primary File Group Full

I'm getting an error when I'm copying data into a table. The error is saying the the Cannot allocate space. Primary File Group Is Full. I've been unable to find any information on the error. Can someone please tell me what this means and how to go abo
ut correcting it?
Thanks
The Primary File Group is the default file group for a database. You will
need to expand one of the files in the primary group or add a new file to
this group.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:95030BF0-28D9-4D26-AE82-07F685DFA63B@.microsoft.com...
> I'm getting an error when I'm copying data into a table. The error is
saying the the Cannot allocate space. Primary File Group Is Full. I've
been unable to find any information on the error. Can someone please tell
me what this means and how to go about correcting it?
> Thanks
|||This is for tempdb, but much of it applies to all DBs
http://www.aspfaq.com/2446
http://www.aspfaq.com/
(Reverse address to reply.)
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:95030BF0-28D9-4D26-AE82-07F685DFA63B@.microsoft.com...
> I'm getting an error when I'm copying data into a table. The error is
saying the the Cannot allocate space. Primary File Group Is Full. I've
been unable to find any information on the error. Can someone please tell
me what this means and how to go about correcting it?
> Thanks
|||The best that I can tell all of my SQL files are part of the Primary File Group and all are set to "Automatically Grow File". Is there something else that needs to be done to avoid this issue?
Gary
"Geoff N. Hiten" wrote:

> The Primary File Group is the default file group for a database. You will
> need to expand one of the files in the primary group or add a new file to
> this group.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:95030BF0-28D9-4D26-AE82-07F685DFA63B@.microsoft.com...
> saying the the Cannot allocate space. Primary File Group Is Full. I've
> been unable to find any information on the error. Can someone please tell
> me what this means and how to go about correcting it?
>
>
|||Thanks, I'll look at this and see if it helps. I still feel a little lost on this one. All of my databases are set to "Automatically Grow" by 10% each time. I'm not sure why I should be getting this error message.
Gary
"Aaron [SQL Server MVP]" wrote:

> This is for tempdb, but much of it applies to all DBs
> http://www.aspfaq.com/2446
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:95030BF0-28D9-4D26-AE82-07F685DFA63B@.microsoft.com...
> saying the the Cannot allocate space. Primary File Group Is Full. I've
> been unable to find any information on the error. Can someone please tell
> me what this means and how to go about correcting it?
>
>
|||Because your disk doesn't have enough space for the file to autogrow?
http://www.aspfaq.com/
(Reverse address to reply.)
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:A5D86758-EC3A-475C-9466-409AD815B0BA@.microsoft.com...
> Thanks, I'll look at this and see if it helps. I still feel a little
lost on this one. All of my databases are set to "Automatically Grow" by
10% each time. I'm not sure why I should be getting this error message.[vbcol=seagreen]
> Gary
> "Aaron [SQL Server MVP]" wrote:
tell[vbcol=seagreen]
|||My C drive has 12gig available and my D drive has 93 gig.
My Master DB, TempDB DB, ect reside on my C drive and the project databases are on my D drive.
"Aaron [SQL Server MVP]" wrote:

> Because your disk doesn't have enough space for the file to autogrow?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:A5D86758-EC3A-475C-9466-409AD815B0BA@.microsoft.com...
> lost on this one. All of my databases are set to "Automatically Grow" by
> 10% each time. I'm not sure why I should be getting this error message.
> tell
>
>
|||Which database is causing this error? What is the current size (show us the
result of sp_spaceused)? Can you also show us the result of sp_helpfile?
http://www.aspfaq.com/
(Reverse address to reply.)
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:956F6496-E606-4550-A405-89B8C577EA8D@.microsoft.com...
> My C drive has 12gig available and my D drive has 93 gig.
> My Master DB, TempDB DB, ect reside on my C drive and the project
databases are on my D drive.
|||OK, here are the results.
sp_spaceused:
Database_name: ICEDataRep
Database_Size: 4490.88 mb
unallocated space: 615.58 MB
reserved: 3275376 KB
data: 3025336 KB
index_size: 11328 KB
unused: 238712
Let me add on other note here. There are many tables in this database and I only seem to get the error on one table. Here are the results:
sp_spaceused 'rClientActualData_arc'
rows: 32217618
reserved 2556216 KB
data: 2353224 KB
index_size: 8 KB
unused: 202984
Results of sp_helpfile
Datafile
Name: ICEDataRep_Data
FileID: 1
FileName: D:\SQL_Data\icedatarep.mdf
filegroup: PRIMARY
size 3905728 KB
maxsize: Unlimited
growth: 20%
usage: data only
Log File
Name: ICEDataRep_log
fileid: 2
Filename: D:\SQL_Data\icedatarep.ldf
filegroup: NULL
size: 692928 KB
maxsize: unlimited
growth: 10%
usage: log only
I'm going to continue to do other testing to see if I can isolate the problem.
Thanks
Gary
"Aaron [SQL Server MVP]" wrote:

> Which database is causing this error? What is the current size (show us the
> result of sp_spaceused)? Can you also show us the result of sp_helpfile?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Gary" <Gary@.discussions.microsoft.com> wrote in message
> news:956F6496-E606-4550-A405-89B8C577EA8D@.microsoft.com...
> databases are on my D drive.
>
>
|||I have seen times were the file just couldn't grow fast enough and this
error appears. It seems to be a tricky timing issue. The trick to avoiding
issues associated with autogrowing of files is to not let it auto grow in
the first place. I see that you have a 20% growth setting on your primary
file. If that is a 4GB file it needs to allocate and format 800MB when it
grows. That can take quite a while depending on the hardware. The larger
the file the more you should not use % for the autogrow size. Set a fixed
MB instead so you know how long it takes to grow and is well within an
acceptable time. Better yet you should schedule a manual or programmatic
growth at a time when there is little activity to avoid autogrow altogether.
Andrew J. Kelly SQL MVP
"Gary" <Gary@.discussions.microsoft.com> wrote in message
news:A5F260BD-1AA6-446C-A37D-C7C26DA58195@.microsoft.com...
> OK, here are the results.
> sp_spaceused:
> Database_name: ICEDataRep
> Database_Size: 4490.88 mb
> unallocated space: 615.58 MB
> reserved: 3275376 KB
> data: 3025336 KB
> index_size: 11328 KB
> unused: 238712
> Let me add on other note here. There are many tables in this database and
I only seem to get the error on one table. Here are the results:
> sp_spaceused 'rClientActualData_arc'
> rows: 32217618
> reserved 2556216 KB
> data: 2353224 KB
> index_size: 8 KB
> unused: 202984
> Results of sp_helpfile
> Datafile
> Name: ICEDataRep_Data
> FileID: 1
> FileName: D:\SQL_Data\icedatarep.mdf
> filegroup: PRIMARY
> size 3905728 KB
> maxsize: Unlimited
> growth: 20%
> usage: data only
> Log File
> Name: ICEDataRep_log
> fileid: 2
> Filename: D:\SQL_Data\icedatarep.ldf
> filegroup: NULL
> size: 692928 KB
> maxsize: unlimited
> growth: 10%
> usage: log only
> I'm going to continue to do other testing to see if I can isolate the
problem.[vbcol=seagreen]
> Thanks
> Gary
> "Aaron [SQL Server MVP]" wrote:
the[vbcol=seagreen]
sp_helpfile?[vbcol=seagreen]