Return
-
Title
How to retain MDF and LDF disk sizes for one year on Spotlight Statistics Repository database? -
Description
User needs to retain MDF and LDF disk sizes of databases for one year. User also needs to retain data and log space used in databases. How to configure Spotlight Statistics Repository to retain this data for one year? They need this to create trending reports. Also, is it possible to import older data on disk sizes? -
Resolution
1. Select Configure | Scheduling option
2. Scroll down and select "Database List" collection
3. Check "Override the default setting ..." checkbox
4. Change store reporting data in the Spotlight Statistics Repository option to 1 year