This content has been marked as final. Show 3 replies
SQL 2008 Express is limited to 4gb of data. I'd be willing to bet you're at that limit.
There's no real solution to that, except upgrading to a full version or SQL Server, even the included Oracle XE has the same size limitation.
Thanks. I will check in that direction, i do remember when i exported the data out it was not that much but i will check
Do you also know if there is any real harm if the 'background jobs' are unable to run for a long period of time ?
In production (i.e. Not a new install), we have started getting something similar:
Exception : EprmDBSQLExecutionFailure
Type : EprmDBSQLExecutionFailure
Event Code : PRMDB-1080-0
PRM DBAccess Error: Database Server Error: Could not allocate space for object 'dbo.REFRDEL'.'ndx_refrdel_table_pk' in database 'pmdb$primavera' because the 'PRIMARY' filegroup is full. Create disk space 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.
As we are approaching the 4GB (4096MB) limit, we are deleting unwanted projects via MS SQL Server as follows:
1) Backup database 'pmdb$primavera'
2) Determine Project ID for Project X
i.e. select proj_id from project where proj_short_name like '<Project X>';
e.g. Gives the result 729
3) Delete Project X
i.e. declare @pret_val int, @pret_msg varchar(1000)
exec project_delete 729, @pret_val output, @pret_msg output, 0
Note: In Step 3, Line 2, 729 is the result of the query in Step 2
I'm unsure if the above helps...
With Best Regards,