Solved

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

Posted on 2008-06-14
4
258 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
  • 3
4 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

HOW TO: Install and Configure VMware vSphere Hypervisor 6.5 (ESXi 6.5), Step by Step Tutorial with screenshots. From Download, Checking Media, to Completed Installation.
HOW TO: Connect to the VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere (HTML5 Web) Host Client 6.5, and perform a simple configuration task of adding a new VMFS 6 datastore.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This video shows you how easy it is to boot from ISO images for virtual machines with the ISO images stored on a local datastore on the ESXi host.

776 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