Re: Shrink temp db
From: Steve Thompson (SteveThompson_at_nomail.please)
Date: 12/23/03
- Next message: Hlin: "Re: Shrink temp db"
- Previous message: Steve Thompson: "Re: Check Sql Before Execute"
- In reply to: Hlin: "Shrink temp db"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 23 Dec 2003 10:44:54 -0500
"Hlin" <henry_lin2001@yahoo.com> wrote in message
news:uQjzJbWyDHA.1760@TK2MSFTNGP10.phx.gbl...
> My tempdb data size is up to 1.5 gb. How do I shrink it
>
Check out the:
DBCC SHRINKDATABASE
command, detail available in books online.
Keep in mind whatever caused tempdb to grow that large may occur again.
Steve
- Next message: Hlin: "Re: Shrink temp db"
- Previous message: Steve Thompson: "Re: Check Sql Before Execute"
- In reply to: Hlin: "Shrink temp db"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
