Hi, Im installing sql server and am required to move tempdb from on directory to another. Can anyone supply me with any code which will enable me to do this?
You will have to change the path to your specified path. Also, to help with performance you should create a tempdb file for each of you CPU's. Check out the FAQ section in here for more information.
Code:
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'D:\programs\mssql\data\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'D:\programs\mssql\data\templog.ldf')
Go
- Paul
- If at first you don't succeed, find out if the loser gets anything.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.