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 RMS (Archived) / Primary filegroup is f...
Microsoft Dynamics RMS (Archived)

Primary filegroup is full what to do

(0) ShareShare
ReportReport
Posted on by Adam Durazo 20

Hello All,

I’ve got a customer with RMS and their database is FULL. The database reads 4GB and some change. So my question is where do I start looking to SAFLEY free up some space? The item catalog seems to be relatively under control with under 10k items. The system has been in place for just over 2 years with 2 locations and around 80 transactions each on a busy day. Should we be looking to archive transactions or some another part of the database that could hogging up space.

Thanks for all your help!

--Adam

*This post is locked for comments

I have the same question (0)
  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at

    Adam, its never really recommended to remove anything from RMS.  That being said, old Journal, Transaction, and TransactionEntry records are where to start as they take up be bulk of the data, but then you loose the ability to report on sales history.  Retail Realms makes an archiving tool that can help with this.

    As a better alternative, Microsoft released SQL Server 2008 Express R2 which bumps update database size limitation to 10GB.  It is not officially supported unless the customer is running RMS 2.0 SP3, but we have used it successfully with many versions of RMS.

    Hope this helps.

  • WLiberty Profile Picture
    WLiberty 191 on at

    Adam,

    Alternatives to freeing up some room (if not ready to upgrade to SQL 2008 R2 or purchase a 3rd party solution) include backing up your existing store database; creating a new database (you'll need to name it something other than your existing db) using your existing store .bck as the source to restore from.  Once restored as a new database  you can delete transactions, or purge history through a date range.  This will maintain your current inventory, customers, suppliers, etc...  

    By switching between databases, the old database can be used for historical reports, lookups etc...

    Lastly, if you are using HQ - Removing inactive worksheets will also free up room.

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 RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans