SqlErrorLog: New resource proposal to update ErrorLog configuration

Details of the scenario you tried and the problem that is occurring

Request a configuration for controlling the error log configuration for a given instance.

Pretty much would be reading and updating the registry entry that controls this for a given instance since it does not exist within the sys.configurations right now.

Would have two options or properties to validate/set:

• LogCount
• LogSize (2012+)

Starting in SQL Server 2012+ you have the option for setting the size limit of a log file with the instance, it will cause it to roll over.

The DSC configuration that is using the resource (as detailed as possible)

N/A

Version of the operating system and PowerShell the target node is running

N/A

SQL Server edition and version the target node is running

N/A

What SQL Server PowerShell modules, and which version, are present on the target node.

N/A

Version of the DSC module you're using, or write 'dev' if you're using current dev branch

N/A

Start by reviewing the existing SqlErrorLog resource and how it accesses configuration, then investigate the registry entry controlling SQL Server error log settings because it is not exposed in sys.configurations. Define how LogCount and the SQL Server 2012+ LogSize properties should be validated and set; the resource should manage both settings for a given instance.