How to create SQL Agent job to automatically restore a database from latest backups?
Solution to the problem is described: 
https://www.mssqltips.com/sqlservertip/1584/auto-generate-sql-server-restore-script-from-backup-files-in-a-directory/