• I have got rid off the extra file now!!

    I then run the following to resize the original file to 650 mb and add a secondary.

    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 second part of the code adds the file with no problems, however the first part of the code does not rezise the primary tempdev (logical name) to 650mb, it stays at 8192kb and this is after i restart the instance