http://support.microsoft.com/default.aspx?kbid=834846 for TechNet Support WebCast: Administering and maintaining the tempdb system database in Microsoft SQL Server This Support WebCast session will discuss the role of the tempdb system database in typical Microsoft SQL Server operations. It will provide a review of the tempdb configuration and specifications, and describe some of the administration and maintenance tasks related to the tempdb database. The session will talk about planning activities, expanding and shrinking tempdb, moving it to another drive, and optimizing its performance. The Support WebCast will also discuss some of the known issues and challenges with maintaining tempdb. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.