The following support solution explains how to utilize the Data Retention feature in SELECTserver 09.xx.xx.xxx to control license database growth. The instructions only apply to users running a deployed (i.e. in-house) SELECTserver. They do not apply to users utilizing Bentley's hosted SELECTserver (also known as SELECTserver Online or Bentley CONNECT SELECTservices).
By default, SELECTserver will store historical usage data indefinitely. This causes large license databases over time. Additionally, SQL Server Express 2005 imposes a size limitation of 4 GB, while SQL Server Express 2008 or later imposes a size limitation of 10 GB. Fortunately, SELECTserver 09.xx.xx.xxx introduced a Data Retention feature that culls old historical usage data beyond a specified duration.
To enable the Data Retention feature, perform the following steps:
Important: Versions prior to SELECTserver 09.01.00.26 possess a defect that can cause the Data Retention function to fail in certain cases. Either apply the following fix, or upgrade to the latest version of SELECTserver.
How to create a new license database
Other Language Sources