Undercover Catalogue 0.2 Hox Fix 2 to Fix Breaking Changes with dbatools 1.0.0 & SQL2008r2/2008 Compatibility Patch RELEASED

Some breaking changes were introduced with dbatools 1.0.0, please make sure that you’ve got the latest version of hotfix 2 installed as well as the lastest Interrogation script running

The minimum version of dbatools that we now support is 1.0.0

Undercover Catalogue 0.2.2

It looks like a bug has crept it’s way into the Undercover Catalogue.

When running with certain versions of DBA Tools, a number of the modules will fail to collect when the Interrogation script is run (this is down to my sloppy coding, no fault of the great guys at DBA Tools). This hot fix will solve that problem.

The hot fix can be downloaded from GitHub, this will need to be run against your central monitoring instance as well as all target instances.

https://github.com/SQLUndercover/UndercoverToolbox/blob/master/SQLUndercoverCatalogue/UndercoverCatalogue%200.2.2%20Hotfix.sql

and the updated interrogation script https://github.com/SQLUndercover/UndercoverToolbox/blob/master/SQLUndercoverCatalogue/CatalogueInterrogation.ps1

SQL 2008r2/2008/possibly 2005 Compatibility Patch (unsupported)

The Databases and Availability Groups modules will fail when run against versions of SQL Server prior to SQL 2012.

We’re going to stand by our decision to only support SQL 2012 onwards but to help out you guys who are still running 2012 and 2012r2 (this may also work on 2005 but it’s not been tested), we’ve put together a compatibility patch for you.

The patch should be applied ONLY to those non-supported instances.

https://github.com/SQLUndercover/UndercoverToolbox/blob/master/SQLUndercoverCatalogue/UndercoverCatalogue%20SQL2008%20Compatibility.sql

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: