How to move the SQL tempDB database files

Open SSMS (If you don’t know what is SSMS, you shouldn’t be doing this…)

Paste and execute this query, modifying it to your needs

Restart the MS SQLSERVER Services.

A new tempDB data and log files will be created in the newly specified location. You can deleted the original ones.

Do not forget, you must assign full control permission to NT SERVICE\MSSQLSERVER  on your new folder prior to moving the files


JohnyLuky has written 54 articles

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">