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

GalenBolin
GalenBolin used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

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

http://support.microsoft.com/kb/224071

tempdb is a system database, and below is an article of how to move system databases

http://deepakrangarajan.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html
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)
Untitled1.png
Untitled2.png

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