Tempdb ! Urgent Help please !



How I can change the tempdb location from C:\ to E:\ drive without any
downtime.

Please send me the query to implement this as I am getting this error.

ERROR MSSQLSERVER
Event ID: 17052

ERORR 1101, Level 17, State 3
Could not allocate new page for database 'TEMPDB'. There are no more pages
available in filegroup DEFAULT. Space can be created by dropping objects,
adding additional files, or allowing file growth.


Thanks in advance.




.