Is there a way to trace the DDL and DML activities performed on Microsoft SQL Server manually?
I'm guessing your Audit was turned off long enough ago to explain why you're only seeing recent data (couldn't tell you how it was turned off though).
Other tools built into SQL Server that might help you with auditing is Change Data Capture and/or you could also look into DDL Triggers.