Solved

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

Posted on 2008-06-14
4
264 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 143

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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
This Micro Tutorial walks you through using a remote console to access a server and install ESXi 5.1. This example is showing remote access and installation using a Dell server. The hypervisor is the very first component of your virtual infrastructu…

828 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