tempdb

Last Post 04 Jun 2008 02:39 PM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
04 Jun 2008 02:39 PM
Hi
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

for example

current file location and name c:\tempdb_2



ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdb_1_Data, FILENAME = 'E:\Data\tempdb_2.NDF')
GO

can i do that?

Thanks


Acceptable Use Policy
---