Home Forums SQL Server 2005 Administering why i can't shrink tempdb data file RE: why i can't shrink tempdb data file
shotman
Right there with Babe
Points: 769
More actions
December 7, 2010 at 12:46 pm
#1259752
Looks like u do have a run away transaction like one of them emntioned. Either terminate that session and run shrink or wait for it to finish. There is no silver bullet to shrink as long as there is an active transaction using tempdb.