I searched in the internet but cannot find clear and direct way. I have a folder which include 100 databases as full backup, another folder contains all logs for these 100 DBs.
I need a script to do the automate restore for these DBs?
The names for backup files are different, for example
and so on, appreciate your help and cooperation.