• Hi

    I have come across a scenario where the temp db after restore or recovery defaults the file size of the mdf and ldf to very large values.

    Also you could check if the filegroeth size is set to a very large percentage.

    Ideally when u restart the sql server service , it is supposed to clear the tempdb and the default size to return to a few MB.

    Also you shud try to find out the temp db usage by running a perfmon to see if the tempdb is growing dynamically or if the size is set by default.