Re: Tempdb ! Urgent Help please !

That means you were trying to say over here that following error comes
because of DATA FILE right not LOG FILE.

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

"Arnie Rowland" <arnie@xxxxxxxx> wrote in message
news:OcYQkBIIHHA.4216@xxxxxxxxxxxxxxxxxxxxxxx
You want to expand the space available to TempDb, so add an additional ndf
file 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:e4Ts19GIHHA.4068@xxxxxxxxxxxxxxxxxxxxxxx
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 !
    ... Should I add .ldf into E drive or .ndf? ... Could not allocate new page for database 'TEMPDB'. ... To move the TEMPDB to E drive you need a down time. ...
    (microsoft.public.sqlserver.clients)
  • Page allocation error
    ... "Could not allocate new page for database 'rough'. ... adding additional files, or allowing file growth." ...
    (microsoft.public.sqlserver.server)
  • Space is not available in TempDB
    ... "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" ...
    (microsoft.public.sqlserver.replication)
  • 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)
Loading