reset the size of temp db

Hi All,
the size of my temp db has increased drastically. I would like to reset it
to the original size.
I tried restarting the sql server but it is not reset.
How can i reset it to the default size (8 mb for the data and .5 for the log
files)
Rgds,
Anu
> How can i reset it to the default size (8 mb for the data and .5 for the log
> files)
Use the ALTER DATABASE command (documented in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anuradha" <Anuradha@.discussions.microsoft.com> wrote in message
news:92FC242B-82B4-4FF8-BDCF-2B56252B6660@.microsoft.com...
> Hi All,
> the size of my temp db has increased drastically. I would like to reset it
> to the original size.
> I tried restarting the sql server but it is not reset.
> How can i reset it to the default size (8 mb for the data and .5 for the log
> files)
> Rgds,
> Anu
|||Hi
use tempdb
dbcc shrinkfile('Tempdev',8,truncateonly)
"Anuradha" wrote:

> Hi All,
> the size of my temp db has increased drastically. I would like to reset it
> to the original size.
> I tried restarting the sql server but it is not reset.
> How can i reset it to the default size (8 mb for the data and .5 for the log
> files)
> Rgds,
> Anu
sql

reset the size of temp db

Hi All,
the size of my temp db has increased drastically. I would like to reset it
to the original size.
I tried restarting the sql server but it is not reset.
How can i reset it to the default size (8 mb for the data and .5 for the log
files)
Rgds,
Anu> How can i reset it to the default size (8 mb for the data and .5 for the logn">
> files)
Use the ALTER DATABASE command (documented in Books Online).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Anuradha" <Anuradha@.discussions.microsoft.com> wrote in message
news:92FC242B-82B4-4FF8-BDCF-2B56252B6660@.microsoft.com...
> Hi All,
> the size of my temp db has increased drastically. I would like to reset it
> to the original size.
> I tried restarting the sql server but it is not reset.
> How can i reset it to the default size (8 mb for the data and .5 for the l
og
> files)
> Rgds,
> Anu|||Hi
use tempdb
dbcc shrinkfile('Tempdev',8,truncateonly)
"Anuradha" wrote:

> Hi All,
> the size of my temp db has increased drastically. I would like to reset it
> to the original size.
> I tried restarting the sql server but it is not reset.
> How can i reset it to the default size (8 mb for the data and .5 for the l
og
> files)
> Rgds,
> Anu