web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / GP 8.0 Database if nea...
Microsoft Dynamics GP (Archived)

GP 8.0 Database if nearly full.

(0) ShareShare
ReportReport
Posted on by JacobCC 40

I have absolutely no experience with GP but I have a client who uses the product.  The error they are receiving is:

 This company's database size is 1.92 GB.  The database limit is 2 GB.  Remove history from your company, or contact your system administrator.

 Now, it is obvious from the error what is occuring however, I thought someone may have a recommendation as to how they should proceed (other than upgrade), if there are other options beside what is listed in the error message.  I appreciate your time and assistance.

 Jacob

MCP, MCTS

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi Jacob--

     

    Sadly, they probably have to remove history.  You could try shrinking the database in SQL, but that will probably not free up enough for it to be a permanent fix.  One option with removing history, though, is that you can back up the database to keep as an archival copy (even create a company to store it in).  So at least they can access it if needed.

     Either that, or upgrade...I know, I know.  Sorry.

    Take care,

    Christina

  • John Carpenter Profile Picture
    John Carpenter 280 on at

     Option 2 is to upgrade your MSDE instance to the free SQLExpress that has 4 gb limit.  You will probably have to apply the latest v8 service pack afterward.

     

    JC

  • JacobCC Profile Picture
    JacobCC 40 on at

    Thank you both for your feedback.  I greatly appreciate it.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans