The ‘Restore Generator’ stored procedure and PowerShell scripts were created in 2012 then an article was published by SQL Server Central. Subsequently a lot of contributions were made to improve it notably in Version 4 by Luke to manage backup forking logic, Version 5 additions by Mick to support Azure URL backup file locations and compatibility with the Ole Hallengren solution. Version 6 includes support for multiple standby server restores running concurrently with help from Kiran (PowerShell script updates), all the new features have been suggested functional improvements.
The screen shot below shows site statistics after Brent Ozar mentioned Restore Gene in May. There were lots of views, downloads, suggestions and bugs reported soon after that.
Categories: Restore Gene