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
Mr_EziAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Anthony PerkinsConnect With a Mentor Commented:
ALTER DATABASE tempdb
ADD FILE (NAME = N'Temp2', -- Name it appropriately
    FILENAME = N'Full Path goes here\Temp2.ndf' ,
    SIZE = 1GB ,          -- Change as appropriate
    FILEGROWTH = 512MB )
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
0
 
Mr_EziAuthor Commented:
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
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Mr_EziAuthor Commented:
any help how to move it?
0
 
Anthony PerkinsCommented:
You don't have to move it.  Just create a new one.
0
 
Mr_EziAuthor Commented:
thank
how do i create a new one
0
 
Mr_EziAuthor Commented:
i need to creat a database first?
0
 
Mr_EziAuthor Commented:
Thanks
0
All Courses

From novice to tech pro — start learning today.