Danny,
Go to CAR>System>Database>Automatic Purge
You can set the duration for whatever you want.
When you run the SQL shrink does it take several minutes and show a big reduction? If you don't select Files and run it from the second window it complete in a few seconds and will show successful, but won't actually do much.
Please rate helpful posts.
Dave