This is the result of running that SQL:

(2 row(s) affected)

Restoring from file:

--======

Msg 3044, Level 16, State 2, Line 7

Invalid zero-length device name. Reissue the BACKUP statement with a valid...

Sorry to be a pain, I'm now getting this error:

Msg 3044, Level 16, State 2, Line 4

Invalid zero-length device name. Reissue the BACKUP statement with a valid device name.

Msg 3013,...

I am not as experienced as perhaps a majority of users on here so I well definitly need some hand holding on this.

Is this how the syntax is supposed to...

I do thank you very much for your assistance with this one but alas this does not work for me.

It does not allow me the flexibility of the actual .bak...

So by your reply I gather this is still an open topic?

So this is the exact syntax I'm using:

declare @file Nvarchar(max)

set @file = N'D:\BKUP\Demo\Demo_backup_200804022315.bak'

RESTORE DATABASE [Demo] FROM DISK = @file

WITH ...

Thank you very much for this however this script looks like it will only restore from a specified filename.

The filename of the .bak in my case is being created daily...