Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / General / Setup / November 2005

Tip: Looking for answers? Try searching our database.

tempdb can not delete it

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
atx - 28 Nov 2005 15:01 GMT
Hi,
after a huge ODBC operation to read some data from a DB table, my tempdb
is now 2.8 GB and I can not delete tempdb. Query analyzer does not work,
right mouse click and delete does not work, dbcc checks does not work. I
even stopped the service and started it again, but tempdb did not
regenerated and still 2.8 GB. I manually deleted the tempdb.mdf file and
log file but after I started the MSSQLSERVER service, they are all
recovered as 2.8 GB.
How can I get rid of this tempdb???
regards,
atx
Reply to this Message
Joe D - 28 Nov 2005 19:41 GMT
First of, Why would you  want to delete that database? It is vital to the
operation of SQL Server.
If you are concern about disk space you could always try dbcc shrinkfile,
once the database is empty.

It is recreated every time SQL Server is shutdown and then restarted. Are
you saying that once you restarted SQL it was still 2.8GB in size? How big
is your model database?

JD

> Hi,
> after a huge ODBC operation to read some data from a DB table, my tempdb
[quoted text clipped - 7 lines]
> regards,
> atx
Reply to this Message
atx - 29 Nov 2005 07:30 GMT
Yes, ı konow it is regenerated normally on restart, but it does not
anymore. It is stuck at 2.8 GB. So, by some means I have to delete it.
But how? DBCC shrink does not work also..
regards,
atx

> First of, Why would you  want to delete that database? It is vital to the
> operation of SQL Server.
[quoted text clipped - 18 lines]
>>regards,
>>atx
Reply to this Message
Andrew J. Kelly - 29 Nov 2005 12:09 GMT
Signature

Andrew J. Kelly  SQL MVP

> Yes, i konow it is regenerated normally on restart, but it does not
> anymore. It is stuck at 2.8 GB. So, by some means I have to delete it. But
[quoted text clipped - 24 lines]
>>>regards,
>>>atx
Reply to this Message
Andrew J. Kelly - 29 Nov 2005 12:09 GMT
http://www.support.microsoft.com/?id=307487

Signature

Andrew J. Kelly  SQL MVP

> Yes, i konow it is regenerated normally on restart, but it does not
> anymore. It is stuck at 2.8 GB. So, by some means I have to delete it. But
[quoted text clipped - 24 lines]
>>>regards,
>>>atx
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.