Knowledge Base Detailed Resolution

Category:

Orion Network Performance Monitor Ver. 7.x

Question:

Why am I receiving the following error message? "Could not allocate new page for database 'Database_Name'. There are no more pages available in the filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth."

Resolution:

This error message is a SQL message stating that the MSDE SQL Server has no room available to compact and repair or to restructure the tables. The MSDE SQL Server has a 2GB limit and the database has either reached this limit or is close. To resolve the issue, you will need to back-up the database and restore it to a Full Standard/Enterprise SQL Server. You will then need to run the Configuration Wizard and point to the new SQL Server.