Hi Adil

You cannot rename tempdb, I am satisfied with Parag Kulkarni Suggestion or
either you can move the tempdb location from c drive to some other drive

Regards

Banga Balvinder
DBA
eMind eLearning Software Services Pvt Ltd
Delhi, India

-----Original Message-----
From: Adil Basha [mailto:[Email Address Removed] Tuesday, October 21, 2003 7:48 PM
To: LazyDBA.com Discussion
Subject: rename tempdb

Hi,
sqlserver 7
I am on production server
My tempdb is occupying all the c drive space.
tempdb.mdf
How can i rename a tempdb
Pls advise wht i should do
Its urgent

TIA
Adil


__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page