SSAS Log retention

  • WhiteLotus

    SSChampion

    Points: 11878

    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: 25761

    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: 90260

    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

     

     

     

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply