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.

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 (AT) hotmail (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote

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 (AT) hotmail (DOT) com> wrote

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 (AT) 1568 (DOT) com> wrote