Hi John, I didn't realise that I could have just leave the logical name as is, I thought by doing that it would be an identical restore in every respect by doing that.

On the matter of of writing the script 5 times, the backup names are changing all the time with regard to the date and time. And I only ever want one database restored ie. CIFT04 as this is my test database, which is why I'm restoring each time from anyone of the 3 live databases.

Hope that explains it better.