Archive for

Moving tempdb

Moving the tempdb database in SQL Server is a simple process but does require the service to be restarted. By default, the tempdb database is created in the same location as master, model and msdb.  tempdb is used to store temporary user created objects (e.g. temp tables), temporary internal objects (e.g. work tables for sorting) … Continue reading