I've inherited a Sharepoint/IIS server. From my best guess the developers and former DBA's were the type to just put up stuff and no one worried about maintenance until they were bit in the butt.
This particular server has SQL Express 2005 and Sharepoint/IIS loaded on it. Using WinDirStat it's showing 10.2 GB of text files. A lot of the files are sharepoint and IIS logs back to October of 2010.
I'm thinking about creating a SQL SP to read the various directories and wipe out files older than 30 days? Then have the SQL Server agent from another server run the SP on a weekly basis.
Any ideas, disagreements, reasons for longer retention would be appreciated.