Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to move tempdb? Expand / Collapse
Author
Message
Posted Thursday, January 10, 2002 8:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 18, 2003 12:00 AM
Points: 15, Visits: 1
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.




Post #2179
Posted Thursday, January 10, 2002 8:58 AM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
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
bkelley@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bkelley/


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #26182
Posted Friday, January 11, 2002 1:20 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, September 18, 2003 12:00 AM
Points: 15, Visits: 1
Thks v. much
Appreciate your help.
regards hans




Post #26183
Posted Friday, January 11, 2002 2:03 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
You're welcome.

K. Brian Kelley
bkelley@sqlservercentral.com
http://www.sqlservercentral.com/columnists/bkelley/


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #26184
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse