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
thanks
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
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
ASKER
any help how to move it?
You don't have to move it. Just create a new one.
ASKER
thank
how do i create a new one
how do i create a new one
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i need to creat a database first?
ASKER
Thanks
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