Preventing Deadlock: allocate

Showing posts with label allocate. Show all posts

Monday, March 12, 2012

PRIMARY filegroup is full?

Error Message
- Task reported failure on execution (SQL DTS). Could not allocate space for
object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
filegroup is full.
SQL Server Info
- SQL Server 2000 Standard Edition
- Intel Xeon 3.06 GHz
- 60 GB HDD
Database Properties
- Size 2,426.69 MB
- Space available 1,047.60 MB
- Data files is automatically grow file and unrestricted file growth
- Transaction Log is automatically grow file and unrestricted file growth
- Filegroups is PRIMARY
Please help.Sam wrote:
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate
> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
> 'PRIMARY filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file
> growth
> - Filegroups is PRIMARY
> Please help.
Could you be running a very large task using DTS that is causing the log
file and data file growth to fill up that last gigbyte of space? Can you
move the log to another drive with more space? How big is the log now?
Can you backup the database or truncate the log file if it's too large?
--
David G.|||The data file (employee.mdf) is 1,872 MB.
The transactiona log (employee.ldf) is 556MB.
"David G." <david_nospam@.nospam.com> wrote in message
news:eGF$l40gEHA.3348@.TK2MSFTNGP12.phx.gbl...
> Sam wrote:
>> Error Message
>> - Task reported failure on execution (SQL DTS). Could not allocate
>> space for object 'TABLE_EMPLOYEE' in database 'Employee' because the
>> 'PRIMARY filegroup is full.
>> SQL Server Info
>> - SQL Server 2000 Standard Edition
>> - Intel Xeon 3.06 GHz
>> - 60 GB HDD
>> Database Properties
>> - Size 2,426.69 MB
>> - Space available 1,047.60 MB
>> - Data files is automatically grow file and unrestricted file growth
>> - Transaction Log is automatically grow file and unrestricted file
>> growth
>> - Filegroups is PRIMARY
>> Please help.
> Could you be running a very large task using DTS that is causing the log
> file and data file growth to fill up that last gigbyte of space? Can you
> move the log to another drive with more space? How big is the log now?
> Can you backup the database or truncate the log file if it's too large?
> --
> David G.
>|||sometime files doesn't grow fast enough, so you get this "database is full" message. I suggest you
pre-allocate storage (also good for performance reasons).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> Error Message
> - Task reported failure on execution (SQL DTS). Could not allocate space for
> object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> filegroup is full.
> SQL Server Info
> - SQL Server 2000 Standard Edition
> - Intel Xeon 3.06 GHz
> - 60 GB HDD
> Database Properties
> - Size 2,426.69 MB
> - Space available 1,047.60 MB
> - Data files is automatically grow file and unrestricted file growth
> - Transaction Log is automatically grow file and unrestricted file growth
> - Filegroups is PRIMARY
> Please help.
>|||Notice that SQL Server 2000 is only permitted 2GB per database.
Therefore, the database shrinked and able to update via SQL DTS.
Could it add more data files into single database so that each of it consist
2GB?
Please advise.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> sometime files doesn't grow fast enough, so you get this "database is
full" message. I suggest you
> pre-allocate storage (also good for performance reasons).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> > Error Message
> > - Task reported failure on execution (SQL DTS). Could not allocate space
for
> > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> > filegroup is full.
> >
> > SQL Server Info
> > - SQL Server 2000 Standard Edition
> > - Intel Xeon 3.06 GHz
> > - 60 GB HDD
> >
> > Database Properties
> > - Size 2,426.69 MB
> > - Space available 1,047.60 MB
> > - Data files is automatically grow file and unrestricted file growth
> > - Transaction Log is automatically grow file and unrestricted file
growth
> > - Filegroups is PRIMARY
> >
> > Please help.
> >
> >
>|||SQL Server support about 1 million TB size for database. Each file can be 32 TB.
However, MSDE has max size of 2GB for data (transaction log not included). Sam doesn't appear to be
running MSDE as data size is already over 2GB.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> Notice that SQL Server 2000 is only permitted 2GB per database.
> Therefore, the database shrinked and able to update via SQL DTS.
> Could it add more data files into single database so that each of it consist
> 2GB?
> Please advise.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> > sometime files doesn't grow fast enough, so you get this "database is
> full" message. I suggest you
> > pre-allocate storage (also good for performance reasons).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> > > Error Message
> > > - Task reported failure on execution (SQL DTS). Could not allocate space
> for
> > > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> > > filegroup is full.
> > >
> > > SQL Server Info
> > > - SQL Server 2000 Standard Edition
> > > - Intel Xeon 3.06 GHz
> > > - 60 GB HDD
> > >
> > > Database Properties
> > > - Size 2,426.69 MB
> > > - Space available 1,047.60 MB
> > > - Data files is automatically grow file and unrestricted file growth
> > > - Transaction Log is automatically grow file and unrestricted file
> growth
> > > - Filegroups is PRIMARY
> > >
> > > Please help.
> > >
> > >
> >
> >
>|||I'm using SQL Server 2000 Standard Edition and how much the size of database
(MDF)?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> SQL Server support about 1 million TB size for database. Each file can be
> 32 TB.
> However, MSDE has max size of 2GB for data (transaction log not included).
> Sam doesn't appear to be
> running MSDE as data size is already over 2GB.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sam" <cybersam88@.hotmail.com> wrote in message
> news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
>> Notice that SQL Server 2000 is only permitted 2GB per database.
>> Therefore, the database shrinked and able to update via SQL DTS.
>> Could it add more data files into single database so that each of it
>> consist
>> 2GB?
>> Please advise.
>>
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in
>> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
>> > sometime files doesn't grow fast enough, so you get this "database is
>> full" message. I suggest you
>> > pre-allocate storage (also good for performance reasons).
>> >
>> > --
>> > Tibor Karaszi, SQL Server MVP
>> > http://www.karaszi.com/sqlserver/default.asp
>> > http://www.solidqualitylearning.com/
>> >
>> >
>> > "Sam" <cybersam88@.hotmail.com> wrote in message
>> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
>> > > Error Message
>> > > - Task reported failure on execution (SQL DTS). Could not allocate
>> > > space
>> for
>> > > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
>> > > filegroup is full.
>> > >
>> > > SQL Server Info
>> > > - SQL Server 2000 Standard Edition
>> > > - Intel Xeon 3.06 GHz
>> > > - 60 GB HDD
>> > >
>> > > Database Properties
>> > > - Size 2,426.69 MB
>> > > - Space available 1,047.60 MB
>> > > - Data files is automatically grow file and unrestricted file growth
>> > > - Transaction Log is automatically grow file and unrestricted file
>> growth
>> > > - Filegroups is PRIMARY
>> > >
>> > > Please help.
>> > >
>> > >
>> >
>> >
>>
>|||In SQL Server 2000 Standard Edition, max size for an mdf file is 32 TB.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sam" <cybersam88@.hotmail.com> wrote in message news:eBe7WmBhEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I'm using SQL Server 2000 Standard Edition and how much the size of database
> (MDF)?
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:eK5e8A5gEHA.3992@.TK2MSFTNGP11.phx.gbl...
> > SQL Server support about 1 million TB size for database. Each file can be
> > 32 TB.
> >
> > However, MSDE has max size of 2GB for data (transaction log not included).
> > Sam doesn't appear to be
> > running MSDE as data size is already over 2GB.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "Sam" <cybersam88@.hotmail.com> wrote in message
> > news:uJOd3n4gEHA.1392@.TK2MSFTNGP11.phx.gbl...
> >> Notice that SQL Server 2000 is only permitted 2GB per database.
> >> Therefore, the database shrinked and able to update via SQL DTS.
> >>
> >> Could it add more data files into single database so that each of it
> >> consist
> >> 2GB?
> >>
> >> Please advise.
> >>
> >>
> >> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> >> in
> >> message news:OrPpO22gEHA.216@.tk2msftngp13.phx.gbl...
> >> > sometime files doesn't grow fast enough, so you get this "database is
> >> full" message. I suggest you
> >> > pre-allocate storage (also good for performance reasons).
> >> >
> >> > --
> >> > Tibor Karaszi, SQL Server MVP
> >> > http://www.karaszi.com/sqlserver/default.asp
> >> > http://www.solidqualitylearning.com/
> >> >
> >> >
> >> > "Sam" <cybersam88@.hotmail.com> wrote in message
> >> news:u7mxWB0gEHA.2984@.tk2msftngp13.phx.gbl...
> >> > > Error Message
> >> > > - Task reported failure on execution (SQL DTS). Could not allocate
> >> > > space
> >> for
> >> > > object 'TABLE_EMPLOYEE' in database 'Employee' because the 'PRIMARY
> >> > > filegroup is full.
> >> > >
> >> > > SQL Server Info
> >> > > - SQL Server 2000 Standard Edition
> >> > > - Intel Xeon 3.06 GHz
> >> > > - 60 GB HDD
> >> > >
> >> > > Database Properties
> >> > > - Size 2,426.69 MB
> >> > > - Space available 1,047.60 MB
> >> > > - Data files is automatically grow file and unrestricted file growth
> >> > > - Transaction Log is automatically grow file and unrestricted file
> >> growth
> >> > > - Filegroups is PRIMARY
> >> > >
> >> > > Please help.
> >> > >
> >> > >
> >> >
> >> >
> >>
> >>
> >
> >
>

Friday, March 9, 2012

Primary Filegroup is Full

I have encounting this problem:

DESCRIPTION: Error: 1105, Severity: 17, State: 2
Could not allocate space for object 'iislog' in database 'IISLOG' because the 'PRIMARY' filegroup is full.

I have check to see if the file is autogrow and it is. Is there a way to solve this problem?

ThanksCan the file grow? Is there enough room on the disk drive?

-PatP|||Yes the file can automatically grow at 10%. The space allocated is 13789MB and the actual file is 15707MB. I raise the automatically grow to 25% and that stop the SQL Messenger from sending me the email. I know it's a quick fix and that there is a major problem that is coming down the pike. Here are the configurations for the disk drive that the file is located on.

Capicity: 67.8 GB
Used: 64.9GB
Free: 2.83 GB

What would I need to do to solve this problem.

The name of the database is IISLOG which will only keep on growing. Because it logs all of the transactions from the intranet.

Please Help!!

Thanks

Lystra|||You need to offload data to another drive...you should be out of space....just....about......now....

It's probably 1 log table......which probably has a date...

You should schedule a nightly process to do this... I think I would bcp out the data...

There's another problem though...the transaction log will have to handle the deletes...|||How would I go about doing this.

Is it possible for me to copy and paste the database file to another drive in order to free up space? Or would I need to write code to do this?

As for the transaction logs they are truncating the logs.

Currently we are using the code below to remove the data, however the code is not removing all of the data and archiving it. It's causing major problem mostly on the weekend.

CREATE PROCEDURE sp_cleanupLOG AS
declare @.Today varchar(10)
select @.Today = convert(varchar(10),getdate(),101)
--select @.Today = '2002-03-30'
/*
delete rows from current iislog table
*/
delete from IISLOG..iislog
where ( LogTime >= DateAdd(day, -1, @.Today) AND LogTime < @.Today )

GO

Also if I use BCP to get the data out, can I schedule it as a job?

Thanks

Lystra|||Dont know whether it is suitable for you!

can you Dump the transaction log (Dump tran <databaseName>) everyday and take a back up of your database to another disk.

regards
Rohit

'PRIMARY' filegroup full error

When adding records that would take a SQL Server
Developer Ed. table over 2 Gb, I receive an error that
says "Could not allocate space for object 'MyTableName'
in database 'MyDb' because the 'PRIMARY' filegroup is
full." What do I need to do to get around this error?
Thanks in advance,
JoeAre you referring the Desktop (MSDE) edition? This is a known
limitation of that edition and there is no workaround.
The Developer edition has no size limitation. You can expand your
database or add additional files to get around the error.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Joe" <joe.murray@.jmaconsulting.biz> wrote in message
news:0fb401c36738$0c3b53b0$a601280a@.phx.gbl...
> When adding records that would take a SQL Server
> Developer Ed. table over 2 Gb, I receive an error that
> says "Could not allocate space for object 'MyTableName'
> in database 'MyDb' because the 'PRIMARY' filegroup is
> full." What do I need to do to get around this error?
> Thanks in advance,
> Joe

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]

Primary File Group Full

I'm getting an error when I'm copying data into a table. The error is sayin
g the the Cannot allocate space. Primary File Group Is Full. I've been una
ble to find any information on the error. Can someone please tell me what t
his means and how to go abo
ut correcting it?
ThanksThe 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 Gr
oup and all are set to "Automatically Grow File". Is there something else t
hat 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% eac
h 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 proble
m.
Thanks
Gary
"Aaron [SQL Server MVP]" wrote:

> Which database is causing this error? What is the current size (show us t
he
> 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]

Monday, March 12, 2012

PRIMARY filegroup is full?

PRIMARY filegroup is full?

PRIMARY filegroup is full?

Friday, March 9, 2012

Primary Filegroup is Full

'PRIMARY' filegroup full error

Primary File Group Full

Primary File Group Full

Preventing Deadlock

Blog Archive

About Me