January 10, 2002 at 8:39 am
Hi there
The disk on which the tempdb (SQL2000) is located is unstable. How do I move the TEMPDB to another location? OR alternatively provide a startup parameter to allow SQL server to startup creating tempdb in a specific location?
Any help appreciated.
January 10, 2002 at 8:58 am
There is a KnowledgeBase article on this very topic. Here you go:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
It has how to move any of the databases, whether user or system. For tempdb, basically it's as simple as a couple of ALTER DATABASE commands and a stop and restart.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
January 11, 2002 at 1:20 am
Thks v. much
Appreciate your help.
regards hans
January 11, 2002 at 2:03 pm
You're welcome.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy