sp_RestoreScript v1.4 – It’s Now Compatible with Case Sensitive Collations, Accepts Wild Cards in DB Names and Fixes A bug

sp_RestoreScript 1.4 is now out and ready for download from our GitHub, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql New Features Compatible with case sensitive collations Now accepts wild cards in the @DatabaseName string, ('Database1,Database2,SQL%') would now be a valid option with % treated as a wildcard. Bug Fixes An issue when using multiple database and @no_recovery = 0 or @standby=1... Continue Reading →

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 →

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 →

Create a website or blog at WordPress.com

Up ↑