Moving tempdb onto a faster drive

Hello all ...

is there a standard procedure or document that explains how to:

Expand tempdb onto a faster drive ... making it larger

then ...

Remove the small portion of tempdb from my c:\ drive to reduce contention?

Thanks!

Doug

So you want to move tempdb to a new location, correct? This should work on SQL 2005, it might work on SQL 2000 as well. See topic "Moving System Databases" in SQL 2005 books online: http://msdn2.microsoft.com/en-us/library/ms345408.aspx

|||

Yup, exactly what I wanted ... move tempdb on to a larger, faster drive with no contention w/ the Windows OS and paging.

Thanks so much!

DB