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