September 4, 2003 at 9:43 am
I am thinking of moving 'tempdb' off the same device that the user dbs are on to reduce contention. I found the Alter database command to do so....
My question is will tempdb be placed on the new device every time sql is started or will it keep putting it on the on specified in model?
Thanks
Randy
September 4, 2003 at 10:05 am
September 5, 2003 at 12:58 am
Yes the location is permanent, you can change size and location of the tempdb by using hint :
sqlservr -c -f
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev , size=220)
go
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog , size=100)
go
ALTER DATABASE tempdb
modify file ( name=tempdev, filename='d:\mssql\data\tempdb.mdf')
ALTER DATABASE tempdb
modify file ( name=templog, filename='e:\mssql\log\templog.ldf')
September 5, 2003 at 12:59 am
Also the you must restart sql server
September 5, 2003 at 5:57 am
Thanks all.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply