[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

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

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
chapmancd
Asked:
chapmancd
  • 3
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
howto: move databases in ms sql server:
http://support.microsoft.com/kb/224071

the section "moving the tempdb" explains it in detail.
0
 
chapmancdAuthor Commented:
Thanks for the quick response. I do appreciate it.
Cory
0
 
chapmancdAuthor Commented:
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
 
chapmancdAuthor Commented:
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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now