G'day Tony
There are a few options. You won't want to archive the data for audit purposes?
Either way, some options are:
- use a definition query on the service to only display the last XX hours
* manually archive data every XX
- have a script / program run daily to delete records
- have a script / program run daily to move 'live' records to archive database