How do I move the tempdb.mdf for Blackberry Enterprise Server

GalenBolin used Ask the Experts™
Thanks to ncheung. He sent a link for best practices for MSSQL. To solve my problem I need to move the database to another drive. I have room on the other drive. I am not a database expert, I just accepted the routine install of Blackberry server. How do I move the database with the least problems.
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
check these links

tempdb is a system database, and below is an article of how to move system databases
Add a new datafile to the database in the drive with free space (see attachement), and disable the autogrowth to the tempdb.mdf file (the first file in the list)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial