Where can I find the size of the database?

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

you can use MS SQL management studio, right click DB and use properties

Was this reply helpful? Yes No
Suggested answer

TheNeos 1,347 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks

Was this reply helpful? Yes No
Suggested answer

archelle16 1,743 on at

Like (0)

Report

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.

Was this reply helpful? Yes No