SSAS Log retention

• WhiteLotus

  SSChampion

  Points: 12120

  More actions

  October 1, 2019 at 4:13 am

  #3684817

  Hi All .

  How do I keep the retention of SSAS log for 1 month worth of log ?

  Thanks

   

   

   

• Michael L John

  One Orange Chip

  Points: 27038

  More actions

  October 1, 2019 at 6:29 pm

  #3685083

  You can't. I think.  It can only be limited by size.  It's a setting in the analysis server properties.

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  October 1, 2019 at 7:36 pm

  #3685108

  WhiteLotus wrote:

  Hi All .

  How do I keep the retention of SSAS log for 1 month worth of log ?

  Thanks

  You never mention which log or what version of SSAS so it's hard to say. Starting with SSAS 2012 SP2, the size and number of logs for msmdsrv.log is configured in the msmdsrv.ini file. The query log doesn't work the same way at all but the properties can be changed when connecting to SSAS with SSMS. You can find these in the following documentation:

  Log operations in Analysis Services

  Sue