We had to restore our master.mdf file. Now when I right click on the properties of the tempdb it shows the path to the tempdb as pointing to the master.mdf file with a logical name of master. I have tried runnng the alter database command and it completes
fine. The new tempdb.mdf file is created in the new location but when I go back in to look at the properties in SQL manager it stilll shows as pointing to the master.mdf file. How can I change? Any help would be greatly appreciated.
View Complete Post