The Shrink Database Feature was Added to Free Up Additional Space

Shrink Database Feature has been Introduced to Free Up Additional Space

Data is a major asset of any organization. Most industries rely on data, especially retail/wholesale markets such as pharmacy stores, grocery stores, supermarkets, restaurants, etc. Achieving the greatest efficiency and error-free management is essential for these marketplaces. Thus, data scrubbing and data cleaning become necessary. It helps to free up the contiguous data blocks and make spaces for newly created files.

In RetailGraph, a new function named 'Shrink Database' has been added. This option is available on the 'Database Health' section of 'Tools'. This feature enables you to free up space that is unnecessarily occupied by files already deleted from the system. With just a tick mark, you can do it yourself. Earlier, this was done by the developer through the back-end. But now, the user can do it themselves. This way, it saves your time to call the query desk and wait till developers resolve.

You can easily navigate to the option by using the following steps:
1. Click on the Start button.
2.Select Database Health from the Tools property.

Database Health


3. Enter Password and click on the Submit button.

Submit button


4. The Database Health window opens.

 Database Health


5. Under the Check and Process ribbon, you will get the option ”Shrink Database”

Shrink Database


6. Tick mark the associated checkbox and click on the Process and Re-Check button.

Process and Re-Check button


Note: By default, the feature is disabled for all existing users; if necessary, you need to follow the above steps.






      • Related Articles

      • Database Health Maintenance System

        Database Health Maintenance System in SwilERP What is a Database Health Maintenance System? Database Health option is generally used when users face speed issues in the software. So with the help of this option, the user can reset the software ...
      • Log and Image Database Settings

        How to Change Log & Image Database in RetailGraph (RG) Software Data is a significant asset of any organization. Most industries depend on data, especially retail/wholesale markets such as pharmacy stores, grocery stores, supermarkets, restaurants, ...
      • Add Free Reward Points

        How to Start Free Reward Points Scheme for Customers in SwilERP (RetailGraph) Free points are a sales promotion marketing strategy for a business to increase interest or demand for a Product. Many segments, such as Departmental stores, Pharma, ...
      • Free Reward Points in Sales Promotion

        How to Apply Free Reward Points Sales Promotion in SwilERP What is Free Points? Reward point-based promotions are used for promoting sales in pharma retail businesses. Each time a buyer makes a purchase from the business, they receive reward points, ...
      • Database Settings In SwilERP

        How to Change or Separate Log and Image Database in SwilERP A user wants to achieve space-free and error-free software for their Pharma company. For that in SwilERP software has given the options to separate its Log and Image database. This feature ...