This morning woke up to an over allocation error and all clips except those from around 2am no longer appear in the clip or alerts views.
Done the standard repair/rebuild/regenerate, also stopped the BI service, made a backup of the DB folder, deleted the contents within, restarted the BI...