I have like around 85 databases to restore, currently all .bak files are in one folder. How can I restore all databases in one run ?
Can we automate this ?
Just FYI: Each databases has multiple ndf files
Answer by Kev Riley ·
Have you looked into the Powershell commands from dbatools?
You might find Restore-DbaDatabase is useful for you: https://docs.dbatools.io/#Restore-DbaDatabase
Upon being passed a list of potential backups files this command will scan the files, select those that contain SQL Server backup sets.