Move Transaction log files
Posted on 2006-10-21
I have setup SQL 2005 on a two node cluster and it is not in production yet.
I have a seperate disk created for the log files and one for the data files.
I set the data location during setup but I can't seem to find information about how to set the log file path.
The reason for the seperate disk is performance.
I did see the default path for log files in the properties of the sql server and I did see the path of the log files in the properties of each database but I would like to be sure of the proper way to set this up before proceeding.
Also, I have found documentation about the tempdb database residing on its own spindle. If I am trying to acheive maximum performance, should I move this tempdb?