Tempdb ! Urgent Help please !
- From: "Rogers" <naissani@xxxxxxxxxxx>
- Date: Thu, 14 Dec 2006 10:39:50 -0500
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.
.
- Follow-Ups:
- Re: Tempdb ! Urgent Help please !
- From: Hari Prasad
- Re: Tempdb ! Urgent Help please !
- From: Arnie Rowland
- Re: Tempdb ! Urgent Help please !
- Prev by Date: Re: AdventureWorks - Difference between WHERE clause and output
- Next by Date: ThreadAbortException when trying to fill a dataset
- Previous by thread: Re: AdventureWorks - Difference between WHERE clause and output
- Next by thread: Re: Tempdb ! Urgent Help please !
- Index(es):