December 30, 2014 at 9:22 am
Hi all,
I restarted SQL server services to free Tempdb but after restart also Tempdb not released disk space , I manually shrink files and seen only 20 GB space got free outof 40 GB disk space (no other files than Tempdb on this drive) , so many temperory fables with name like #00728E are there in Temperory Table list.
I am not getting understand Why these tables are not droped after restart and also Why Tempdb not releasing space.
Please guide Me
Regards,
Shivrudra W
December 30, 2014 at 9:33 am
They should be dropped if they're not system tables. Perhaps you have an application connecting or you are running some queries? SQL Agent?
How are you checking for temp tables? Also, not clear what you mean by disk space? What is 20GB, what is 40GB?
January 2, 2015 at 2:03 pm
Since that drive is dedicated to tempdb - why are you concerned with recovering disk space? Let it use what it needs...
As for the objects - do you have snapshot isolation turned on for any user databases? That would account for objects being created in tempdb and seeming to not disappear after a restart.
Another way to confirm is to stop SQL Server and remove (copy to another location - to be safe) all tempdb files. When you restart SQL Server it will recreate the files. If the files already exist - SQL Server reuses those files. It is possible that object references in tempdb will remain through a restart - but it is just the definition and no data.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply