<div>
Thanks for the quick response. I do appreciate it.<br />
Cory
</div>


<div>
Thanks. I have been moving databases with the &quot;detach&quot; and &quot;attach&quot; function, I just did not think it would work with the system databases. Not sure why, but I did. Thanks again. <br />
<br />
Cory
</div>


<div>
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.<br />
<br />
Thanks again,<br />
<br />
Cory
</div>


<div>
<div class="content wysiwyg-content">
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. &nbsp;How is this done?
</div>
</div>


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?

Thanks for the quick response. I do appreciate it.
Cory

Thanks. I have been moving databases with the &quot;detach&quot; and &quot;attach&quot; function, I just did not think it would work with the system databases. Not sure why, but I did. Thanks again. 

Cory

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

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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.