Test Log Shipping With DbaChecks


Reading Time: 2 minutes

I’ve kind of wrote a lot about log shipping the last few months and this is another one of them.
This time I’m talking how to test log shipping with dbachecks.

DbaChecks?! What is that?

DbaChecks is a brand new module developed by the community to test your environment for all kinds of best practices. There are even possibilities to export the data in such a way that you can create amazing dashboard in Power BI.

The module uses Pester to test a whole lot best practices. Because of that we can test very quickly what’s wrong with our server(s).

These tests are all included in the module:


Why this blog post

We want everyone to know about this module. Chrissy LeMaire reached out to me and asked if I could write some tests for the log shipping part and I did.

Because I wrote the log shipping commands for dbatools I was excited about creating a test that could be implemented into this module for everyone to use.

Test Log Shipping With DbaChecks

If you want to go all nuts you can use the following command and see all the tests fly by

invoke-dbccheck all checks

To make it easier to read I would only want to know about the things that failed

To test for a certain group of test you can use a tag of specify a certain test

invoke-dbccheck logshipping


Using this module will really help you to check your entire SQL Server infrastructure with ease. So what are you waiting for, download the module and go test your instances.


Leave a Reply