Category: ToolBox

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

0

What if it all grows out?!

The other day I got thinking about what would happen if all databases on a single instance grew out, every single one of them! but not just once, what if they all grew out three, four or fives times overnight - what would things look like? Well I know the likelihood may be slim but... Continue Reading →

1

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 →

1

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 →

1

Create a website or blog at WordPress.com

Up ↑