SQL Server – Number of Error Log Files

  Background Trying to review error logs on one of our SQL Server Instances and discovered that it is likely that the error logs we might have to mine is so far back and we might no longer have it. And, so took to see if we have¬†properly calibrated the Number of Error Logs Files … Continue reading SQL Server – Number of Error Log Files

SQL Server – Reading Instance Configuration saved in Registry

Background For a script that I am working on, I need to access System Properties such as the base folder of the errorlog.   SQL Server Management Studio ( SSMS ) Of course the information is available via SSMS, just click on the Server's Property and you will see something like this...   Explanation We … Continue reading SQL Server – Reading Instance Configuration saved in Registry