I want to move temp files AND THE LOG FILES TO THE OTHER PYSICAL DRIVE

• bubby

  SSCertifiable

  Points: 5638

  More actions

  June 10, 2009 at 4:40 pm

  #134988

  Hello,

  I would appreciate if I can get help with this,

  My Tempdb and templog files and data log files are D Drive, I have another physical drive name L, I need to know How I can move these files to L drive, It will great if I can get instructions in GUI,

  Thanks in Advance,

  Dev

• WayneS

  SSC Guru

  Points: 95461

  More actions

  June 11, 2009 at 2:19 am

  #1007829

  This might help you out.

  http://www.lmgtfy.com/?q=sql+server+2005+move+tempdb+site%3Amicrosoft.com

  Wayne
  Microsoft Certified Master: SQL Server 2008
  Author - SQL Server T-SQL Recipes

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2