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 using multiple database and @no_recovery = 0 or @standby=1 would leave databases in NO_RECOVERY has now been fixed.
Leave a Reply