one of my temp dbs on one of the serves has six files and four of them dont have extention
should i bother fixing it
can i drop these four files and add four new files
Also i want to move temp db can i give new fil names then or when i move files have to have same names
current file location and name c:\tempdb_2
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdb_1_Data, FILENAME = 'E:\Data\tempdb_2.NDF')
can i do that?