After 5-6 years of using RMS we are having a few issues. I think is the db size. Where can I see the size of the DB? and do I have to look at the store level individually to see if we have met the SQLExpress quota or the HQ one? Kind of confused here.
Thanks
*This post is locked for comments
You can check the size of ur database through the Store/HQ Administration. Open store op admin of hq admin. Connect to your database first. Once verified, hover mouse to "Database" menu, then click "Properties". You will then see the size of your database as well as the space left and other information.
thanks
Dan,
With SO Administrator that came with RMS connect to your database, and select "database button" from menu bar then select "Properties". This will give you all sorts of information including the size and how full is it. SQL Express 2005 quota is 2000Mb where in SQL 2008 Express is 4000Mb.
If it reaches capacity the common error is that it will not record your receipts and transactions may be not complete. in that case deleting old journal entries and reindexing database can give space. But ... always before you start anything backup your database first.
you can use MS SQL management studio, right click DB and use properties
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (