Link to home
Start Free TrialLog in
Avatar of Mr_Ezi
Mr_Ezi

asked on

tempdb in msSql2005 used all my disk space

the tempdb is 4 gb big 1st i want to know if is a problem  to move it to other drive  and 2nd what do need to make it smaller because it used all my disk space
thanks
Avatar of Aneesh
Aneesh
Flag of Canada image

Hello Mr_Ezi,
you can create another file on another drive too, if it seems like a space isssue with your drive  

http://support.microsoft.com/kb/307487

Regards,

Aneesh
Avatar of Mr_Ezi
Mr_Ezi

ASKER

thanks aneeshattingal for you help...
what is the best way to move
my problem is the the database is in use and i can't stop it maybe for 1-2 min I can
Avatar of Mr_Ezi

ASKER

any help how to move it?
You don't have to move it.  Just create a new one.
Avatar of Mr_Ezi

ASKER

thank
how do i create a new one
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Ezi

ASKER

i need to creat a database first?
Avatar of Mr_Ezi

ASKER

Thanks