Thanks for the confirmation. Will go ahead with the restore.

Yes the drive is an NTFS drive.

SQL Server service account has full permissions to the folder with the data files.

It's Standard edition.

Have run the query and received the following output:

Msg...