SQL - Maintenance - Moving Databases
This issue has come up a few times within our environment and I saw it posted this morning on the forums so I thought I would share this information. On occassion, you may see the volume on which your SQL instance is installed have a drastic space reductions. Many times this is due to the temp database exploding in size, generally due to excessive queries to the SMS database. In our case I had been creating, adjusting and testing many large SQL reports within Enterprise Manager. Needless to say, Ops gave me a call to let me know our server "was full."
Here is a nice article on how to move both the master and temp databases. (I've only moved the temp.)
http://www.databasejournal.com/features/mssql/article.php/3379901