01-21-2013 08:45 AM - edited 01-21-2013 08:49 AM
Get the following message while trying to open our database:
Could not allocate space for object 'dbo.CTL_SYNCROW_DELETE'.'CTL_SYNCROW_DELETE_PK' in database 'Doramics' because the 'PRIMARY' filegroup is full. create discspace by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
After reading some posts I accessed ACTDIAG on the server and tried to carry out a Check, Repair & Reindex on the database.
When I selected Check/Repair I received the following meassage on both occasions -
Could not allocate space for object 'dbo.CTL_EVENTLOG'.'CTL_EVENTLOG_IF1' in database 'Doramics' because the 'PRIMARY' filegroup is full. create discspace by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowthon for existing files in the filegroup.
However after a while i received a message saying task was complete.
When I selected Reindex I received the following meassage -
Could not allocate a new page for database 'Doramics' because of insufficient disc space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup. The statement has been terminated.
This task did not appear to take place.
Microsoft XP Professional Version 2002 Service Pack 3
ACT! by Sage Premium 2008 (10.0) (ST Edition) Version 10.0.1.199
Database ADF File 4,180,352KB
Database ALF File 1,024KB
01-21-2013 09:34 AM
You'll want to verify the version of SQL 2005 you have installed. It appears you have 'Express', which has a 4gb limit on database size. If that is correct, you will need to install the 'Standard' version of SQL which has an unlimited db size (ADF).
You would need to uninstall the 2005 Express ACT7 instance, install SQL 2005 Standard and use the following article to create the ACT7 instance: KB Article 19231
Another option is to upgrade to Sage ACT! 2013, which uses SQL 2008 R2 Express with a limit of 10gb.
02-26-2013 03:33 AM
I managed to restore a back-up of my batabase which allowed access.
I deleted all data over 1 year old but the database still remains the same size.
Under Tools - I selected Lock Database and then Check & Repair.
I get a Database Checkup Error - An error has been found. for thid to be fixed a database lock will have to be applied would you like to repair the database?
I select Yes - almost immediately I receive the following warning : Object reference not set to an instance of an object.
I then get chucked back to the log in screen??
02-26-2013 09:42 AM
Not sure which end of me is up at the moment!!!
So I would like to approach this problem from afresh.
I know the database will fall over if I continue to use because of space issues although I also think there is some corruption with the database.
I have restored a saved version of the database
ADF File - 4,180,352 KB
ALF File - 8,704 KB
Do I - through actdiag reindex etc on the server or do i delete old data first.
02-26-2013 09:57 AM
02-27-2013 10:00 AM
Again - appreciate your advice.
Ran Check and Repair under the Tools-Database Maintenance option.
I did not lock the database.
After a while - received the following message:
An error has been found. For this to be fixed a database lock will need to be applied would you like to repair the database.
I select yes and for a while a "Working" icon appears and then the ACT screen clears.
Unfortunately I only now notice another warning box with the following message:
Object Reference not set to an instance of an object.
I click OK and the logon screen presents itself.
Click OK and get the following message:
A repair database lock has been placed on this database.
Click OK and once again I am on a greyed out Act screen with the top blue bar indicating that the Doramics Database is locked.
Not sure if anything is going on in the backround......
02-27-2013 01:56 PM