PowerShell, Pester and Ola Hallengrens Maintenance Solution
'If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and click the link and look at the easiest way to ensure that all of your essential database maintenance is performed. You can also watch a video from Ola at SQL Bits
Recently I was thinking about how I could validate that this solution was installed in the way that I wanted it to be so I turned to Pester You can find a great how to get started here which will show you how to get Pester and how to get started with TDD.
This isn’t TDD though this is Environment Validation and this is how I went about creating my test.
First I thought about what I would look for in SSMS when I had installed the maintenance solution and made a list of the things that I would check which looked something like this. This would be the checklist you would create (or have already created) for yourself or a junior following this install. This is how easy you can turn that checklist into a Pester Test and remove the human element and open your install for automated testing
-
SQL Server Agent is running – Otherwise the jobs won’t run
-
We should have 4 backup jobs with a name of
-
DatabaseBackup – SYSTEM_DATABASES – FULL
-
DatabaseBackup – USER_DATABASES – FULL
-
DatabaseBackup – USER_DATABASES – DIFF
-
DatabaseBackup – USER_DATABASES – LOG
-
We should have Integrity Check and Index Optimisation Jobs
-
We should have the clean up jobs
-
All jobs should be scheduled
-
All jobs should be enabled
-
The jobs should have succeeded'...
Trackbacks
Die Kommentarfunktion wurde vom Besitzer dieses Blogs in diesem Eintrag deaktiviert.
Kommentare
Ansicht der Kommentare: Linear | Verschachtelt