question

sanjeev.matte avatar image
sanjeev.matte asked

Three months History in ExecutionLogStorage

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....
ssrs-2008-r2historyexecution-log
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
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][1] site. Hope it helps. [1]: http://technet.microsoft.com/en-us/library/bb934303%28v=sql.105%29.aspx
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Usman Butt avatar image Usman Butt commented ·
BTW, I think there is a procedure which is used behind the scenes. I guess the command could be exec SetConfigurationInfo @Name=N'ExecutionLogDaysKept',@Value=N'90'
1 Like 1 ·
sanjeev.matte avatar image sanjeev.matte commented ·
Thanks for your time. In ConfugurationInfo table i got the ExecutionLogDaysKept column and i changed the value to 90.
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.