Clean logs in the repository
Sometimes the repository database become very large. This is normally due to the logs. Thankfully there is some ways to remove old data.
Clean the execution log
It can be removed from the logs in the Repository Administration Tool. A period needs to be chosen as well. Ideally choose every thing until the first of January of the current year.
When a period have been chosen, it shows you the data and projects. It is possible to specify what project is used as well.
To select all of them. Start by marking the bottom line, then go to the top line and mark that while pressing shift. Now press the check box and all lines are chosen and they can be deleted.
We previously had a request where cleaning up the schedule logs were not enough. It was still too big. We have a system table database that is called sysssislog and it contains data regarding all executions where ssis is used and is one of the largest tables in the repository.
It is possible to shrink this as well, even though it is a more advanced job. I have a script that removes all fields not containing error messages.
delete from dbo.sysssislog where event <> 'OnError'
It just needs to be executed against your repository and it will remove all lines that does not contain error information.