Can anybody please advise on the last few comments ? The original file has not grown when i restart the sql server instance - the second file has been added and sized correctly. The code i typed was:

ALTER DATABASE TEMPDB

MODIFY file

(NAME = TEMPDEV , SIZE = 650MB

,MAXSIZE = UNLIMITED,

FILEGROWTH = 10% )

ALTER DATABASE TEMPDB

ADD FILE (NAME = N'TempDev2',

filename = N'D:\DEV\MSSQL10_50.dev\MSSQL\DATA\tempdb2.ndf',

SIZE = 650 MB,

MAXSIZE = UNLIMITED,

FILEGROWTH = 10% )

The original size of the primary file was 8mb - when the server started again it was still 8mb and not 650mb. I have noticed that we only have Service Pack 1 installed - would this be the reason the file is not growing to 650mb when i restart the server ? (By the way when i say restart the server i dont mean a hard reboot i just mean by clicking restart on the instance)