Re: reset the size of temp db

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 09/01/04 

Date: Wed, 1 Sep 2004 08:33:05 +0200

> 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

Relevant Pages

  • Re: How to check for the password reset of SA
    ... Mike Epprecht, Microsoft SQL Server MVP ... > admin and i want to check when the password was reset as ... > Best regards ...
    (microsoft.public.sqlserver.programming)
  • Re: Reset Identity Column
    ... Either truncate the table (it will automatically be reset) ... Wayne Snyder, MCDBA, SQL Server MVP ... I have an identity column that ... However it keeps counting from the last ...
    (microsoft.public.sqlserver.server)
  • Re: Lost SA Password
    ... There is one other way to get reset your sa password to blank and reset the ... Copy the master data file and log file to another SQL Server. ... Attach the database as mastersa or some thing like that. ... >>Also don't have sa login, ...
    (microsoft.public.sqlserver.security)
  • Table access privileges
    ... I'm not super familiar with all of the forms of SQL Server replication, ... I have reset those so that you can ... added and that the final destination system had permission reset on more ... SQL Server 2000 on all machines. ...
    (microsoft.public.sqlserver.replication)
  • Passwords getting reset?
    ... we have a SQL Server 7.0 application running on NT. ... We are having problems with the passwords getting reset or expired. ... there a stored proc that we can add some kind of trace statement that ...
    (microsoft.public.sqlserver.security)