I'll need to check what provisions are available in SQL Server for compacting and archiving data. There might be a way to cut down the petition database's size while still leaving it accessible, at least for browsing. Report