AnsweredAssumed Answered

UIM Database Backup Strategy

Question asked by kanandaguberan on Jan 12, 2016
Latest reply on Jan 12, 2016 by DavidM

Hi,

 

We have our UIM database server being backed up at a regular schedule, however I do not see an existing job that truncates/deletes the old data. Is it advisable to truncate the old data which are backed up.

 

There are 3 tables which are being used at the start up of our MOM tool CA SOI namely

 

CM_CONFIGURATION_ITEM

CM_DEVICE

CM_COMPUTERSYSTEM

 

And it turns out that the numbers on these tables are quite overwhelming. When trying to drill down for this issue we found that there is no truncation happening in our database and I suspect that these high numbers are due to the server not being truncated which ultimately not starting up the tool. Any suggestion on this please.

 

-kag

Outcomes