not sure if you answered this question but this saves me from typing it out. regards terry
he mdf file on the production server is located in a folder that doesn't exist on the test server. On the "Options" tab of the Restore Database dialog box, modify the file locations under "Restore as".
If you try to restore a file from another server and the folder locations for the mdf, ldf or ndf files do not exist, you must override the settings. You can modify the file locations on the “Options” tab of the “Restore Database” dialog box. If you script the restore, you must use the “WITH MOVE” clause.
A restore can be performed if the database does not exist on the server first. If you are a member of the sysadmin role, you already have all rights of the other server roles