I had a 26 Gig tempdb.mdf file . I did everything exactly as i postted. After everything was done, the size was only 100mb.

I just did this yesterday. I followed a microsoft knowledgebase article and it worked perfectly.

How you fix it-

1..Shut down SQL Services on SQL Backend.

2. Go to cmd prompt and Run as Administrator

5.Go to the Binn directory of the SQL Server instance. In...