/* Actually, it is not the projects that take most of the database size - it is history records. We do need the history for Burn Down and other reports, so we cannot drop it completely. However, the history storage mechanism is far from being perfect - saves all the details of story/bug on every action For example it saves description if you just change effort. So, it is more or less safe operation to remove the description from history table if we need to reduce the size of the database. To do that, make a database backup and execute the following queries: */ DECLARE @past_date DATETIME SET @past_date = '2015-12-31 23:59:59.999' UPDATE UserStoryHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE TaskHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE BugHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE FeatureHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE TestCaseHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE RequestHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE CommentHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE CustomFieldHistory SET Value = NULL WHERE Date < @past_date AND Value IS NOT NULL UPDATE TestStepHistory SET Description = NULL, Result = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE EpicHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL UPDATE ProjectHistory SET Description = NULL WHERE Date < @past_date AND Description IS NOT NULL