I am trying to create a weekly job which restores two databases: one from
production to test and another test db on the same test server. To
accomplish the first task, I'm using the sp_attach_db procedure but I'm
having difficulty with an aspect of this - please see below.
from a backup the physical name obviously changes. How do I declare this as
a variable and just use the variable in the script?
Sorry for the juvenile question but I'm new to this.