I have just resolved the problem.  I took a full copy of the database and put it on the standby server.  I then took a backup of the database and restored...

Still no luck.  I have been trying to do the restore through enterprise manager.  I did have the options tab checked for moving files.

I am not sure what QA...

Thank you for your reply.  I will try out your suggestion in the morning when my brain feels a little fresher.  I will let you know how I get on.

Thank you.

Device activation error. The physical file name c:\data\sqldata\MSSQL\DATA\finpower_filename.mdf may be incorrect. File finpower_filename cannot be restored to c:data\sqldata\MSSQL\DATA etc use WITH MOVE to identify a valid location for the...