Tag Archives: How To Move TEMPDB to a new drive

How To Move TEMPDB Files to a new drive ? (Video)

Moving a tempdb files is a often task for a DBA supporting a big environment. Moving a tempdb is 4 step easy process. 1. Current tempdb location, make a note of current file location using the following code. use tempdb go sp_helpfile 2. Check and confirm that new location, where you want to place a [...]