Home Forums SQL Server 2005 Administering why i can't shrink tempdb data file RE: why i can't shrink tempdb data file

  • April 4, 2016 at 5:32 am

    #1869452

    ganesh.01 (4/3/2016)

    But now I have same issue again with a new twist. Temp db log file hos grown to 169 GB on the disk but If i try to shrink it via SSMS UI, it says file size is 2 GB only and out of that X gb is utilized Y gb space is free.

    Why so? Why SQL is behaivng like this? Can someone please help asap?

    You will get more assistance if you start a new thread with all the details (not just this snippet) of what you did and what messages you're receiving when you do it.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.