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 Full documentation on sp_RestoreScript can be found at https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/ 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... 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

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 →

UNDERCOVER TOOLBOX: sp_WhatsMyAG

Here's a quick one for you.  If you happen to be managing SQL Servers with a large number of databases and availability groups, it can sometimes be difficult to keep track of which database belongs to which availability group. sp_WhatsMyAG will tell you just that.  You can either provide it with the database name and... Continue Reading →

sp_AGReconfigure 1.1 is now available

sp_AGReconfigure 1.1 is now available HERE and on GitHub V1.1 includes a new Parameter and some minor bug fixes: @Readable NULL - DEFAULT:  Ignore Readable secondary check (acts as though you are using V1) 0 - Produce a statement to switch readable secondary off if switched on 1 - Produce a statement to switch readable... Continue Reading →

Create a website or blog at WordPress.com

Up ↑