Re: Tempdb ! Urgent Help please !

Have you tried expanding the file? (OR are you out of space on the disk?

You should be able to add an additional file located on the E:\ drive.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:eDqxXY5HHHA.4056@xxxxxxxxxxxxxxxxxxxxxxx
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.






.