All editions of Promodag Reports can use an SQL Server Express LocalDB database to store data. The product creates file formats that use the .mdf and .ldf file extension.
Note: The size limit set by Microsoft to this type of databases is 10 GB (10,240 MB).
There are no specific software requirements for creating and managing an SQL Server Express LocalDB database using Promodag Reports. Microsoft SQL LocalDB 2017 is delivered with the installation package.
Promodag Reports creates an SQL Server Express LocalDB named instance with the name Promodag. Any user on the computer can create a database using this instance of LocalDB, store files under their user profile, and run the process under their credentials. By default, access to the instance of LocalDB is limited to its owner. The data contained in the LocalDB is protected by file system access to the database files. If user database files are stored in a shared location, the database can be opened by anyone with file system access to that location by using an instance of LocalDB that they own. If the database files are in a protected location, such as the users data folder, only that user, and any administrators with access to that folder, can open the database. The LocalDB files can only be opened by one instance of LocalDB at a time.
Note: SQL Server Express LocalDB always runs under the users security context; that is, LocalDB never runs with credentials from the local Administrator's group. This means that all database files used by a LocalDB instance must be accessible using the owning user's Windows account, without considering membership in the local Administrators group.
When you delete a record from a database, the space allotted for that record continues to be held in reserve by the database and it is not released for reuse. If you never compact - or "shrink" - your database, it will retain the "wasted" space and continue to consume additional space to accommodate additional data. To avoid generating excess amounts of wasted space and corrupting your database, you must shrink your database periodically.
Promodag Reports does not manage database backup tasks. Therefore, we recommend you to backup your database regularly.
Promodag Reports uses the database to permanently store the data it needs to generate reports.
Data is collected and added to the database during message tracking file imports. The database will keep on growing unless you decide to clear data using the Tools > Purge Message Tracking Data and Tools > Purge IIS Data options in Promodag Reports.
We strongly recommend you to purge and compact your database once it has approximately reached 9 GB in size, i.e. 90% of the 10 GB size limit, or to create a new one.
If not, the database may be trying to expand beyond 10 GB due to temporary tables created by PROMODAG Reports while it generates reports. In this case, you will receive various error messages.
See also: