I feel really stupid 🙂

I have been looking at it all day and never saw the insert statement commented out.

Thanks!!

There are some more problems now but I will look at it tomorrow,

Looks like the variable substitution is failing.

Thanks all so far!!

Msg 5105, Level 16, State 2, Line 102

A file activation error occurred. The physical file name '@data_file_path@restore_as@mdf_extension' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 3156, Level 16, State 3, Line 102

File 'U4S33_Data' cannot be restored to '@data_file_path@restore_as@mdf_extension'. Use WITH MOVE to identify a valid location for the file.

Msg 5105, Level 16, State 2, Line 102

A file activation error occurred. The physical file name '@data_file_1_path@restore_as@ndf_extension' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 3156, Level 16, State 3, Line 102

File 'U4S33_Data1' cannot be restored to '@data_file_1_path@restore_as@ndf_extension'. Use WITH MOVE to identify a valid location for the file.

Msg 5105, Level 16, State 2, Line 102

A file activation error occurred. The physical file name '@log_file_path@restore_as@ldf_extension' may be incorrect. Diagnose and correct additional errors, and retry the operation.

Msg 3156, Level 16, State 3, Line 102

File 'U4S33_Log' cannot be restored to '@log_file_path@restore_as@ldf_extension'. Use WITH MOVE to identify a valid location for the file.

Msg 3119, Level 16, State 1, Line 102

Problems were identified while planning for the RESTORE statement. Previous messages provide details.

Msg 3013, Level 16, State 1, Line 102

RESTORE DATABASE is terminating abnormally.