Re: Tempdb ! Urgent Help please !

Hari & Arnie,

Should I add .ldf into E drive or .ndf ?

The error was...
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
"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:%23wUik2FIHHA.2236@xxxxxxxxxxxxxxxxxxxxxxx
Thanks Hari & Arnie, now the question is should I add .ndf file into E
drive or .ndf and .ldf both into E Drive? please advice.

Thanks


"Hari Prasad" <hari_prasad_k@xxxxxxxxxxx> wrote in message
news:uHD4sz%23HHHA.5104@xxxxxxxxxxxxxxxxxxxxxxx
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: Tempdb ! Urgent Help please !
    ... Could not allocate new page for database 'TEMPDB'. ... adding additional files, or allowing file growth ...
    (microsoft.public.sqlserver.clients)
  • Re: Tempdb ! Urgent Help please !
    ... Most good judgment comes from experience. ... Should I add .ldf into E drive or .ndf? ... Could not allocate new page for database 'TEMPDB'. ...
    (microsoft.public.sqlserver.clients)
  • Re: Thank you very much...again
    ... For information about the Microsoft Strategic Technology ... Protection Program and to order your FREE Security Tool Kit, ... | delete..etc permissions on tempdb. ... |>database which would avoid some of this. ...
    (microsoft.public.sqlserver.security)
  • Re: Can I move tempdb?
    ... Tempdb file name changes take affect after SQL Server is restarted and are ... reference posted by details procedures for moving other database files. ... Model isn't used to determine database file locations. ...
    (microsoft.public.sqlserver.server)
  • How many logical volumes for large database?
    ... We are about to migrate a large database server onto new ... Logs, and TempDB. ... First, we had four available SCSI channels, so by creating four arrays each ... course TempDB grows and shrinks as needed. ...
    (microsoft.public.sqlserver.server)