PrimaverArena.com | Your best Primavera P6 source on the web

This is caused when using SQL Server 2005 Express and you have reached the maximum database limit.  The database limit with SQL Server Express 2005 is 4 GB.

Solution

To resolve the error so that you can continue working in P6, try one of the following options:

Option 1 – Shrink Database

1. Log into Microsoft SQL Server Management Studio Express
2. Right-click on database
3. Select Tasks
4. Select Shrink
5. Select Database

Option 2 – If the error references the REFRDEL table try the following

Truncate REFRDEL table

Data in the REFRDEL table can be truncated, however this should only be done with ALL users logged OUT of the Project Management database. All retention of data in the REFRDEL table will be lost after this process has been completed. To TRUNCATE, run the following query:

1. Log into Microsoft SQL Server Management Studio Express as the sa user
2. Select the New Query button
3. Run this against your Project Management database (make sure the database is selected in the drop down):

TRUNCATE table REFRDEL;

Option 3 – Upgrade to full version of SQL Server 2005/2008