runal_jagtap (9/18/2012)
What are the steps for setting the tempdb datafile & log files to other locations???
The same as i detailed above 😉
You just need to restart the SQL Server service to recreate the TempDb in the new locations, no need to reboot.
Ensure that any new database file locations have sufficient ACLs applied to allow the database engine service account to access them.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉