error with drop database 1

[FALCONSEYE]

I created a database a while ago. It's called tempDB. Since we run out of space on the hard drive, I have to get rid of this database. The tempdb.mdf takes over 4 gigs of space. When I try to run
drop database tempdb
i get the following error:
Server: Msg 3708, Level 16, State 7, Line 1
Cannot drop the database 'tempdb' because it is a system database.

All the tempDB has is bunch of system tables. Is there a way to either shrink the mdf file or get rid of the database?
thanks

http://www.jetansolutions.com

 

[gmmastros]

>> I created a database a while ago.

Uh... no you didn't. TempDB is a system database. You cannot create a database named TempDB because it already exists (it's created at the time you install SQL Server).



-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[Crowley16]

erm, you created a user database called tempDB? *supress shudder...*

surprised you were able to do that since tempDB is a system database used by sql server to store temporary processing information and other stuff.
are you sure you weren't just using the existing tempDB?

you cannot get rid of tempDB but you can shrink it, however you may need to restart the server/agent services first, this should automatically clear the tempDB.

p.s. I would recommend you read a book or go on a course before messing about with any live production server...

--------------------
Procrastinate Now!

 

[FALCONSEYE]

huh, i run the dbcc shrinkdatabase (tempdb, 25)
which solved my problem

http://www.jetansolutions.com

 

[ptheriault]

By restarting services or the server it doesn't shrink the Tempdb but creates a new one. Take a look at the create date of the tempdb next time you restart services or reboot the server.


- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[SQLDenis]

Star for you man, you just cheered up my day

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[LNBruno]

Anyone want to hazard as guess as to what J.E.T.A.N. might stand for? ;-)

< M!ke >
[small]Holidays cause stress. Crazy people crack under stress. Consider yourself warned.[/small]

 

[ca8msm]

Yikes!


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]