Re: Tempdb ! Urgent Help please !

Hello,

To move the TEMPDB to E drive you need a down time. But you could add one
more file for TEMPDB database to E drive. This will make
sure that reboot is not required.

Thanks
Hari


"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.






.

Relevant Pages

  • Re: use of tempdb by union all
    ... > You are certainly correct about table variables using the tempdb database, ... Andrew J. Kelly SQL MVP "Tenaya" wrote in message ... > You are certainly correct about table variables using the tempdb database,> and not being entirely memory resident ... ...
    (microsoft.public.sqlserver.programming)
  • Re: Error Granting DB / Role Access
    ... the database or object owner (within tempdb) even though they have DBO ... The script below executes correctly. ... >> Now the owner of the tempdb database is SA, and the dbo login is mapped to ...
    (microsoft.public.sqlserver.security)
  • Re: Tempdb ! Urgent Help please !
    ... now the question is should I add .ndf file into E drive ... To move the TEMPDB to E drive you need a down time. ... more file for TEMPDB database to E drive. ... ERROR MSSQLSERVER ...
    (microsoft.public.sqlserver.clients)
  • Re: use of tempdb by union all
    ... You are certainly correct about table variables using the tempdb database, ... and not being entirely memory resident ... ... are you stating the SQL Server will use the ...
    (microsoft.public.sqlserver.programming)
  • Tempdb
    ... that when tempdb database will be created so it auto create one user which ... for tempdb so it deletes that user when sql service stop and when the ... that user has been vanished from the sql server tempdb ...
    (microsoft.public.sqlserver.clients)
Loading