Friday, March 9, 2012

Primary filegroup is full error!

Hi everybody,
I developing a database solution currently 22GB with 4.5GB datafiles.
I ran into below error and can't figure out how to work around it.
"Error 1105: Could not allocate space for object '(SYSTEM table id: 8)' in
database 'fasion_spring04' because the 'PRIMARY' filegroup is full.
Extending database by 1.00 MB on disk 'fashion_018'
I have created a second filegroup called "images" but even when I add a
datafile to the "images" filegroup I get this error.
Any idea how to resolve this.
Thanks in advance
Christian> I have created a second filegroup called "images" but even when I add a
> datafile to the "images" filegroup I get this error.
No data will go to the second filegroup until you explicitly create a table
on that filegroup.
What you should probably do is add a second file to the primary filegroup,
on a different drive with plenty of free space. Then, you should sit down
and decide where this is going to live, because obviously it is outgrowing
its current environment.
http://www.aspfaq.com/2446 (this isn't just for tempdb)
http://www.aspfaq.com/2471

No comments:

Post a Comment