Moving TEMPDB logs only

• muchmoishe

  SSC Rookie

  Points: 33

  More actions

  December 12, 2007 at 11:40 am

  #71200

  We're dedicating new disk space for logs and I need to move tempdb's log only. I've searched this forum and have found entries where both the mdf and ldf are being moved at the same time, but is it possible to move only tempdb's log file to a different drive?

  If so, can I do it with

  ALTER DATABASE tempdb MODIFY FILE (NAME=templog, FILENAME = 'drive:\templog.ldf') ?

  Thanks for your consideration

• Eshwaran

  SSC Veteran

  Points: 229

  More actions

  December 18, 2007 at 7:11 am

  #761001

  Hi,

  Wht ever the command you have mentioned will work.

  once again from master..

  ===================

  Alter database tempdb modify file (name = templog

  , filename = 'PATH_TO_NEW_LOCATION_OF_TEMPDB_DATAFILE\templog.ldf')

  go

• SQL_ABD

  SSCertifiable

  Points: 5832

  More actions

  December 18, 2007 at 10:40 am

  #761139

  Hi,

  Like Eshwaran said, check this link for more info http://support.microsoft.com/kb/224071

  Regards,

  Ahmed