Solved

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Non-Destructive Way of Extending Volume 15 64
Horizon licensing question 5 58
Move VM from site to another site? 7 53
Could not power on VM : msg.vmk.status.VMK_NO_SPACE. 6 58
Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
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.
Teach the user how to install vSphere Update Manager  Console to Windows system:  Install vSphere Update Manager: Configure vSphere Update Manager plug-in in vSphere Client: Verify vSphere Update Manager settings in vSphere Client:
Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…

914 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