There are several ways of automating the SQL Server restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backup files that exist.