Hi kom,
Thank you for using the Support Forum. Please take a look at the support site for CentreWare Web and search on SQL. There are several articles there that may help to resolve your issue. If the articles do not help please consider contacting your local support centre for additional assistance.
Hi
I am Database administrator in an organization using a software Equitrac CentreWare Web
I came across the database used by this software and it has been running fine since 2013.
It has been logging a lot of old transactions, and the database seem to be bigger and bigger everyday.
Please advise maintenance process, howto or script, such as "SQL-Script" that purge old data from the database.
Database Type: SQL Server 2008
Database Name: EQCAS
Database Size: 9.6GB