Removing 2nd TEMPDB file

• jsqldba

  SSChampion

  Points: 11257

  More actions

  July 26, 2001 at 9:33 am

  #57594

  When SQL Server 7 was installed, the original tempdb was on the C: drive. Later, someone defined another tempdb file on the D: drive (a faster drive). The one on C: is primary (I suppose that is what the key symbol means in Enterpise Manager / Right Click Database / Properties).

  How do I delete the C: one and make the D: one primary? I see a KB article on moving tempdb, but don't know how to safely delete one of the files.

  Thanks

  Jay

  KB Article:

  http://support.microsoft.com/support/kb/articles/q224/0/71.asp?LN=EN-US&SD=gn&FR=0&qry=Moving%20TEMPDB&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=SQL

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  July 26, 2001 at 5:11 pm

  #417299

  Once you move it and restart successfully, you can just remove the old temp.mdf.

  Andy

  Andy
  Connect with me on LinkedIn