Re: tempdb can not delete it
- From: atx <atx@xxxxxxxxx>
- Date: Tue, 29 Nov 2005 09:27:38 +0000
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
Joe D wrote:
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
"atx" <atx@xxxxxxxxx> wrote in message news:ec7prwC9FHA.2832@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: tempdb can not delete it
- From: Andrew J. Kelly
- Re: tempdb can not delete it
- From: Andrew J. Kelly
- Re: tempdb can not delete it
- References:
- tempdb can not delete it
- From: atx
- tempdb can not delete it
- Prev by Date: Re: Antivirus
- Next by Date: Re: SQL 6.5 to 2000 Upgrade Troubles
- Previous by thread: tempdb can not delete it
- Next by thread: Re: tempdb can not delete it
- Index(es):
Relevant Pages
|
