AnsweredAssumed Answered

Cleaning out old historic data from SQL

Question asked by JoeSu on Aug 30, 2017
Latest reply on Oct 7, 2018 by DavidHobbs

Hi Guys, 


I am attempting to clear out the snow databases within SQL and remove any historic data (metering information, agreements, licenses, computers, devices, virtual information, system users etc.) from old customers of ours. The reason for this is that there has never been a process in place to remove this data and therefore it must be having a negative effect on the data update job's execution time and the overall performance of the snow portal.


I can see there is an automated process whereby when you remove a customer from the SMACC, it will generate a pop-up message to ask if you want to 'delete it immediately' which is essentially removing all the historic data etc. from SQL automatically without any user interaction. 


We have multiple customers in the database that was not removed this way by selecting the button, and therefore there is loads of unwanted data taking up a lot of space. Does anyone have any processes/ideas of how to remove this information entirely from the database? 


Many Thanks,