Second file missing from Tempdb after move/restart
Posted on 2009-04-15
I created a second file for tempdb on a MSSQL 2005 box. Later I needed to move the tempdb to a new disk. I did a move and everything looked fine. (no errors).
After I restart, the server comes up fine but it does not have the second file for tempdb.
I recreated a second file and again the server seemed okay with that file. after the server was reset however that file also disappeared.
If I try to add the file back with the same name it says it already exists but when I view the properties of tempdb it says there is only one datafile.
I would like to know where tempdb stores the names of the second file and what can be done to "restore" access to them. I would be okay with removing them, but I don't think it is a good idea to create new ones everytime.