Thank you so much for replying.

But I am looking for a script to restore databases regardless of whether they are red gate backups or regular backups. Something which is done automatically as a job.