Solved

tempdb in sql server 2008 path

Posted on 2009-07-14
3
226 Views
Last Modified: 2012-05-07
Best practise for tempdb path is to not have it on same disk as user databases?  Is ok to have it on the same disk where I have the log-files? How do I move the tempdb?
0
Comment
Question by:syssju
3 Comments
 
LVL 75

Expert Comment

by:Aneesh Retnakaran
ID: 24852851
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdb_Data, FILENAME = 'D:\SQLData\tempdb_Data.mdf');
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdb_Log, FILENAME = 'D:\SQLData\tempdb_Log.ldf');
0
 
LVL 60

Accepted Solution

by:
chapmandew earned 125 total points
ID: 24852853
How to move:http://www.databasejournal.com/welcomead/

Yes, it should be OK w/ the log files...would be better by itself, but better w/ the log files than the data files.
0
 

Author Closing Comment

by:syssju
ID: 31603422
thanks
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now