Its recommended to move the TEMP DB transaction
log files towards a dedicated location.
- Open
'Microsoft SQL Server Management Studio"
- Connect
to a SQL Instance
- Select
'Databases'
- Select
'System Databases'
- Select
'master'
- Right
click 'New Query'
- Enter the
following string and change the file path according to the instance
you are changing.
use master
go
alter database tempdb modify file (name = templog, filename =
'E:\DBLog\templog.ldf')
go
- Press
'Execute'
- Launch
'SQL Server Configuration Manager'
- Select
'SQL Server 2005 Services'
- Right
click SQL Server(DB Instance) and select 'Restart'.
The file templog.ldf should now be present at the new
location.
- Repeat at
these steps on each instance present on this cluster.
1. Hardware
