Dear Professional,

One quick question, is there any way we can shrink tempdb database and don't
need to restart SQL Server services?

Thanks in advance

Here are the supported ways to shrink tempdb.

http://www.support.microsoft.com/?id=307487

--
Andrew J. Kelly SQL MVP

"Rogers" <naissani (AT) hotmail (DOT) com> wrote

Is there any I can shrink tempdb data file but don't want to restart the
services?

Thanks

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Hello,

You could use DBCC SHRINKFILE.

use tempdb
go
-- this command shrinks the data file
dbcc shrinkfile (tempdev, 'target size in MB')
go
-- this command shrinks the log file
dbcc shrinkfile (templog, 'target size in MB')
go

Thanks
Hari

"Rogers" <naissani (AT) hotmail (DOT) com> wrote

Thanks hari, but this command is secure and not harmful to run in the
production box right.


"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> wrote

if you do so during period of no activity there should not be any problems.
Schedule a job out of hours.

"Rogers" <naissani (AT) hotmail (DOT) com> wrote