[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Can I move the tempdb.mdf file from the root/system drive to another physical drive?

Posted on 2008-06-14
4
Medium Priority
?
279 Views
Last Modified: 2010-04-21
I am setting up a new SQL Server to handle the database for VMWare installation. VM Ware recommends the databases and logfiles be separated, and if possible, move the tempdb.mdf file to a new location on another physical drive. If that is not possible, then to move the tempdb.mdf to the same drive as the log files.  How is this done?
0
Comment
Question by:chapmancd
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1000 total points
ID: 21784882
howto: move databases in ms sql server:
http://support.microsoft.com/kb/224071

the section "moving the tempdb" explains it in detail.
0
 

Author Closing Comment

by:chapmancd
ID: 31467176
Thanks for the quick response. I do appreciate it.
Cory
0
 

Author Comment

by:chapmancd
ID: 21784916
Thanks. I have been moving databases with the "detach" and "attach" function, I just did not think it would work with the system databases. Not sure why, but I did. Thanks again.

Cory
0
 

Author Comment

by:chapmancd
ID: 21784923
angellll - just a quick, non-related question - did you get the points? It seemed to me, the last question I asked, gave me the opportunity to award the points. That option was never offered this time.

Thanks again,

Cory
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
Giving access to ESXi shell console is always an issue for IT departments to other Teams, or Projects. We need to find a way so that teams can use ESXTOP for their POCs, or tests without giving them the access to ESXi host shell console with a root …
Teach the user how to rename, unmount, delete and upgrade VMFS datastores. Open vSphere Web Client: Rename VMFS and NFS datastores: Upgrade VMFS-3 volume to VMFS-5: Unmount VMFS datastore: Delete a VMFS datastore:
This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

656 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