Re: How can I shrink my TempDB Databse?


"Elham Ghoddousi" <Ghoddousi@xxxxxxxxx> wrote in message
news:1122113370.807529.57670@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>I have a problem with my TEMPDB Database.It gets extra size through
> importing data into one of my databases in same server.
> How can I shrink my TempDB Databse?
>
> Thanks
>

http://support.microsoft.com/default.aspx?scid=kb;en-us;307487

Simon


.

Relevant Pages

  • Re: Moving tempdb
    ... there are two databases on the server that are being used. ... I also have another server running a database about 16GB in size. ... I'm planning on moving our tempdb to it's own LUN but I'm not sure what ...
    (microsoft.public.sqlserver.setup)
  • Lost Permissions after Rebooting Server
    ... databases including tempdb. ... But is happens to non tempdb databases. ... Recently the server was rebuilt from 2K to 8K pages. ... Seems like every sucessive reboot, ...
    (comp.databases.sybase)
  • How can I shrink my TempDB Databse?
    ... importing data into one of my databases in same server. ... How can I shrink my TempDB Databse? ...
    (comp.databases.ms-sqlserver)
  • Re: RAID Setup (RAID 1 with RAID 10)
    ... faster DATA array for SQL. ... Depending on how much your tempdb is being used, you could also gain some performance by putting this on it's own array. ... If you backup your databases to a disk on the server, it's also highly recommended to have this on a separate array. ...
    (microsoft.public.sqlserver.setup)
  • Re: Tempdb after restart
    ... If SQL has to auto-grow tempdb there are severe ... performance penalties. ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)