ok in sql server 2005 this would be restoring from a backup that is already present on the hard drive
In sql server management console - right mouse database name select tasks - restore - database
then choose from 'device'
navigate to the .bak file on the hard drive
Next place the check mark in the backup file being utilized
next click 'options'
next CHECK 'overwrite existing database'
next in the window where it says 'original file name' and restore as
change the restore as to the correct path/database files for .mdf and.ldf files
NOW - NORMALLY if you click back to 'GENERAL' and then click back AGAIN to OPTIONS your update to the restore as will remain intact
On this server when I come back to options it reverts back to what it was before I changed it. PLEASE HELP
this is sql server 2005 standard and it is patched to sp2
What can I do - i tested on another server and it behaves correctly it is only this 'production server' that is the problem.