Home Forums SQL Server 2008 SQL Server 2008 Administration Shrinking Temp DB RE: Shrinking Temp DB

  • October 4, 2013 at 11:13 am

    #1655988

    Bhuvnesh (10/3/2013)

    dwilliscp (10/2/2013)

    I am trying to shrink the first temp db mdf, but it is not shrinking

    IN two cases , size will not get reduced.

    1) Shrink will not work on active transational part.

    2) size will not get reduced below initial size.

    Ah.. number 2 would explain it.. How do you get it to shrink below the size it was created with... Alter Database tempdb Modify File (name = temp1.mdf, size=100mb).. then wait for a reboot?