Sidd's SQL Solution

The always progressive IT industry is moving at faster pace today than it ever was and this trend will going to continue in future too. This progressive industry has made everyone very familiar with words like migration, upgrade, DR (Disaster Recovery) or BCP (Business Continuity Plan) etc. as these are the activities which are being performed more often now all thanks to cheaper hardware and new versions of software releasing every year. In database world one activity which is common to all the above stated activities and is done even more often than them is database refresh. Activities like migration and upgrade are big projects and not performed as often as activities like DR drills or pre-production database refreshes or may be setting up Always-on, which are more likely to require to restore all databases from PROD. Implementation Keeping this high requirement of such database refresh activity in mind, I’ve created below script which can read backups from a given loc