469,111 Members | 1,985 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

Could not allocate space for .. error


I am getting a "Could not allocate space for object 'temp_trc' in database
'Test' because the 'PRIMARY' filegroup is full"

The database test has unrestricted growth (All the defaults). It resides on
drive c which has 4Gigs free. I added new data and log files on drive d
which is about 30G free. I know that my insert doesn't take even 1G disk
space.

Why is the database complaining about a full filegroup when I just expanded
it?

J.
Jul 20 '05 #1
1 6466
John Dalberg (jo*****@hotmail.com) writes:
I am getting a "Could not allocate space for object 'temp_trc' in database
'Test' because the 'PRIMARY' filegroup is full"

The database test has unrestricted growth (All the defaults). It resides
on drive c which has 4Gigs free. I added new data and log files on drive
d which is about 30G free. I know that my insert doesn't take even 1G
disk space.
How big is the database now, and how much is set to grow at a time? The
default is 10%, so if the database is 43 GB, it cannot expand on C.
Why is the database complaining about a full filegroup when I just
expanded it?


What size did you make the data file on D? It may be that you need to
turn off auto-grow on the first file, so that SQL Server does not try
to expand that file first.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by lixiaoyao | last post: by
2 posts views Thread by Oliver Stratmann | last post: by
6 posts views Thread by Peter Hickman | last post: by
20 posts views Thread by ramasubramanian.rahul | last post: by
17 posts views Thread by dtschoepe | last post: by
11 posts views Thread by Bryan Parkoff | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.