"Rogers" <naissani@hotmail.com> wrote in message
news:%23ftnxjVSHHA.996@TK2MSFTNGP02.phx.gbl...
> 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
>

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:%232yM8hYSHHA.1000@TK2MSFTNGP05.phx.gbl...
> Here are the supported ways to shrink tempdb.
>
> http://www.support.microsoft.com/?id=307487
>
> --
> Andrew J. Kelly SQL MVP
>
> "Rogers" <naissani@hotmail.com> wrote in message
> news:%23ftnxjVSHHA.996@TK2MSFTNGP02.phx.gbl...
>> 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
>>
>
>

"Rogers" <naissani@hotmail.com> wrote in message
news:u29%23VTsSHHA.480@TK2MSFTNGP02.phx.gbl...
> Is there any I can shrink tempdb data file but don't want to restart the
> services?
>
> Thanks
>
> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
> news:%232yM8hYSHHA.1000@TK2MSFTNGP05.phx.gbl...
>> Here are the supported ways to shrink tempdb.
>>
>> http://www.support.microsoft.com/?id=307487
>>
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "Rogers" <naissani@hotmail.com> wrote in message
>> news:%23ftnxjVSHHA.996@TK2MSFTNGP02.phx.gbl...
>>> 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
>>>
>>
>>
>
>

"Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
news:%235SHLKvUHHA.1000@TK2MSFTNGP05.phx.gbl...
> 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@hotmail.com> wrote in message
> news:u29%23VTsSHHA.480@TK2MSFTNGP02.phx.gbl...
>> Is there any I can shrink tempdb data file but don't want to restart the
>> services?
>>
>> Thanks
>>
>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>> news:%232yM8hYSHHA.1000@TK2MSFTNGP05.phx.gbl...
>>> Here are the supported ways to shrink tempdb.
>>>
>>> http://www.support.microsoft.com/?id=307487
>>>
>>> --
>>> Andrew J. Kelly SQL MVP
>>>
>>> "Rogers" <naissani@hotmail.com> wrote in message
>>> news:%23ftnxjVSHHA.996@TK2MSFTNGP02.phx.gbl...
>>>> 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
>>>>
>>>
>>>
>>
>>
>
>

"Rogers" <naissani@hotmail.com> wrote in message
news:%23$QgmdDVHHA.4028@TK2MSFTNGP04.phx.gbl...
> Thanks hari, but this command is secure and not harmful to run in the
> production box right.
>
>
> "Hari Prasad" <hari_prasad_k@hotmail.com> wrote in message
> news:%235SHLKvUHHA.1000@TK2MSFTNGP05.phx.gbl...
>> 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@hotmail.com> wrote in message
>> news:u29%23VTsSHHA.480@TK2MSFTNGP02.phx.gbl...
>>> Is there any I can shrink tempdb data file but don't want to restart the
>>> services?
>>>
>>> Thanks
>>>
>>> "Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
>>> news:%232yM8hYSHHA.1000@TK2MSFTNGP05.phx.gbl...
>>>> Here are the supported ways to shrink tempdb.
>>>>
>>>> http://www.support.microsoft.com/?id=307487
>>>>
>>>> --
>>>> Andrew J. Kelly SQL MVP
>>>>
>>>> "Rogers" <naissani@hotmail.com> wrote in message
>>>> news:%23ftnxjVSHHA.996@TK2MSFTNGP02.phx.gbl...
>>>>> 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
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>