Releases seem to be coming out thick and fast at the moment, here's the latest v1.6 revision to sp_restorescript For those of you backing up to Azure BLOB Storage, we've now added a @Credential parameter. You can grab the latest version from our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql or for full documentation, visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
We've released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our GitHub repo, https://github.com/SQLUndercover/UndercoverToolbox/blob/master/sp_restorescript.sql or for full documentation, visit https://sqlundercover.com/2017/06/29/undercover-toolbox-sp_restorescript-a-painless-way-to-generate-sql-server-database-restore-scripts/
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 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
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here. Bert has a great topic for this month, he wants us to write about code you’ve written that you would hate to live without. I have found the SQL server community to be extremely helpful... Continue Reading →
The first SQL Undercover podcast where Adrian introduces the Undercover Inspector, David releases sp_restorescript 1.2 along with a bit of nonsense chit chat.