|
In SQL Server 2008 R2, How to maintain the three months history in ExecutionLog? By default it stores only two months history.Recently i heard that there is an option to maintain the history more that two months.can anyone help me in this. Thanks in advance....
(comments are locked)
|
|
There is a Server property named "ExecutionLogDaysKept" for Reporting Services, which can help you to increase the retention period. For more information please visit the Technet site. Hope it helps. Thanks for your time. In ConfugurationInfo table i got the ExecutionLogDaysKept column and i changed the value to 90.
Apr 06 '12 at 08:51 AM
sanjeev.matte
It is the same as what you would have done from the Serverproperties. I prefer not to touch the tables unless no other option is available.
Apr 06 '12 at 09:13 AM
Usman Butt
BTW, I think there is a procedure which is used behind the scenes. I guess the command could be
Apr 06 '12 at 09:48 AM
Usman Butt
(comments are locked)
|
