Moving the Tempdb and Master Database in SQL Server 2000

CXO

Moving the Tempdb and Master Database in SQL Server 2000

By steven s. warren October 18, 2006, 6:02 AM PDT

Image
1
of 5

Wally

There have been many occasions where I found it necessary to move the database and log files to different drives to increase performance. When you want to move a typical user database to a different drive for performance or to split out the logs, you run sp_detach and sp_attach to perform the move. However, when it comes to moving the Master and Tempdb database, different rules apply.

Wally

Wally

3. Zoho 0.JPG — Moving the Tempdb and Master Database in SQL Server 2000

Wally

4. OSRMT 1.JPG — Moving the Tempdb and Master Database in SQL Server 2000

Wally

Wally

By steven s. warren

Steven S. Warren is a popular author residing in Winter Haven, Florida with his wife and 2 children. As a columnist on such well-known IT web sites as Techrepublic.com, CNET, and ZDNET, Steven has published numerous articles. Additionally, Steven

Account Information

Contact steven s. warren

Your message has been sent
|
See all of steven s.'s content

The importance of diversity and inclusion in any given organization cannot be overstated. It establishes a level playing field, brings together people with different backgrounds, perspectives, traditions and ideas and enriches company culture by ensuring fairness and tolerance. This helps build a more effective and collaborative workforce which enables the business to run in a ...

Software development is a complex process that involves a specific series of steps (known as the development lifecycle) to transform a concept into a deliverable product. The steps involved with creating the finished product must be carefully adhered to yield the best results, reduce inefficiencies and maximize customer satisfaction. The purpose of this policy from ...

Cybersecurity demands and the stakes of failing to properly secure systems and networks are high. While every organization’s specific security needs form a unique and complex blend of interconnected requirements, numerous security fundamentals almost always apply to each of these groups. It stands to reason that cybersecurity pros who effectively identify network and systems risks ...