I am in need of a special SQL restore script. Basically, I have a drive with all my .bak files - I want to restore all these databases and place them in a different drive in the same manner.
E:\Backups\21221\[url removed, login to view] - Each backup is in its own directory on the drive
D:\Data\21221\[url removed, login to view] and .ldf - the database restored will be in its own directory as well.
This is on a Microsoft SQL Server 2012 Enterprise version.