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 runningThe 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.... Continue Reading →

sp_restorescript 1.3 Released

sp_restorescript v1.3 is now available. We had found instances where backups consisting of multiple backup files were causing the length of the restore command to exceed the maximum character limit. 1.3 deals with this problems. Please visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ for full documentation on sp_restorescript The procedure can also be downloaded from out GitHub site https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql

To use ALTER DATABASE, the database must be in a writable state in which a checkpoint can be executed. – when moving files on an Availability Group secondary.

Here's a little error that I stumbled across the other day when trying to migrate the data files of an Availability Group secondary node onto a nice new SAN. I started off by running the following command against the secondary server. ALTER DATABASE SQLUndercover MODIFY FILE (NAME = 'AG01', FILENAME = 'E:\DATA\AG01.mdf') There's nothing wrong... Continue Reading →

Inspector V1.4 now available

The SQL Installation script can be found here The Inspector sample report has been updated here All of the below Git Issues can be found on the V1.4 Project page #68 Added a new table [Inspector].[ExecutionLog] which will hold elapsed time for each of the stored procedures executed during a collection, this table is truncated... Continue Reading →

#TSQL2sDay – #112 – Mini cookies

This months TSQL Tuesday is hosted by Shane O'Neill (Blog | Twitter) Shane explains the Topic as: Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance from them.   Cookie One: is remembering... Continue Reading →

Create a website or blog at WordPress.com

Up ↑