Primary file group is full error message

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I am trying to delete a record in BCM and I get an error message saying that
my 'Primary' file is full and it suggests setting "autogrowth" to on.

How do I do that? I can see the database file but I cannot see autogrowth in
it's properties. Many thanks, Bruce
 
How big is the size of your database when you go to Business contact manager
database tools > Manage database
Click to expand...

Also can you give me the exact error details when you try deleting the entry
?

The auto growth can only be seen through Microsoft SQL Management studio
--
Regards

Rahul Thomas

MSFT
 
In my case
MB = 3320
Full error message follows:
could not allocate space for object 'dbo.changequeue' in database
'mssmallbusiness' because the 'primary' filegroup is full. create disk
space by deleting unneeded files, dropping objects in the filegoup, adding
additional files to the filegroup, or setting autogrowth on for existing
files in the filegoup.


Error dependably appears when record is selected in Business Contact Manager
then pressing delete.
 
On a related note:
When I select one record in the deleted items folder in BCM 2007 (195,301
records) and press delete the error message pops up:
some items cannot be deleted. They were either moved or already deleted, or
access was denied.

When I select the deleted items folder in BCM 2007 and then right click to
"Empty deleted items folder".
A small status window opens and informs me it will take 12 hours to clear
the records. Yet at the end of the time period the records remain with no
change.
 
On a related note:
When I select one record in the deleted items folder in BCM 2007 (195,301
records) and press delete the error message pops up:
some items cannot be deleted.  They were either moved or already deleted, or
access was denied.

When I select the deleted items folder in BCM 2007 and then right click to
"Empty deleted items folder".
A small status window opens and informs me it will take 12 hours to clear
the records.  Yet at the end of the time period the records remain withno
change.








- Show quoted text -
Click to expand...

Considering you have close to 200 thousand records, your database size
may be close to, if not already at, the 4GB limit. The database is in
a state where it isn't safe to perform the delete operation. It might
be possible to free up enough space via some selective deletes of
child items like history items (start with one at a time, eventually
enough space should be freed up to do larger batches). If that
doesn’t work it would take direct SQL DML to rectify the issue, and
you could and probably should follow up with PSS directly.

John
 
Back
Top