filegroup name is full

wiro · 2006-11-09

Hi again all

I have a problem when i want to post a journal with a lot of records (1000), the message is :
could not allocate space for object company name in database name
because the filegroup name if full.

I don't understand because i can post a journal before.
What is the meaning of filegroup name?

Thanks in advanced.

ara3n · 2006-11-09

Are you on sql? Have you set your file for unrestricted growth?
If no increase the size of the db.

Also are you running by any chance the express version? It has a limit on sql 2000 to 2 gig and on 2005 4 gig.

wiro · 2006-11-09

Thank you ara3n.

Yes, i'm on sql and i have set the file for unrestricted.
I use sql 2000 and we have 12 company.
If i use 1 company, the posting is success.

ara3n · 2006-11-09

How much free space do you have on harddrive? How full is the database? Also are you running MSDE version of SQL?

Yes when you post 1 entry you are not filling the db. post 1 journal 1000 times and you'll get the error.

wiro · 2006-11-09

Thanx again ara3n.

My free space on harddrive is 4 Gb,
database file ndf is 1,7 Gb
log file is 1,2 Mb
mdf is : 273 Mb

When i use 1 company there is no problem, is it problem with so many companies?

ara3n · 2006-11-09

No it's not the number of companies.

A filegroup is full when
1. the disk on which its files live become full OR
2. The MAXSIZE of the files have been reached.

Go to Sql Enterprise Manager -> Databases -> properties and check/change the
maxsize of your data files.

Also in navision. click on files->database->info. what percentage is filled up?

wiro · 2006-11-09

Thank you very much.
It works.

ara3n · 2006-11-09

you are welcome.

filegroup name is full

Answers

Categories