Thank you for useful information.

Thank you. It works.

I tried couple of different things and it worked finally. Logical name and physical was not matching.

Thank you all.:)

restore db step failed.

sp_help db test gave result test db does not exist.

Again in a nutshell I am trying to automate db and tran log restore via sql job.

I have...

1) what's the info in the job step history.

The job succeeded.

The Job was invoked by User test\dbadmin.

The last step to run was step 3 (Restore test...