September 5, 2002 at 8:15 am
Is there a way to shrink tempdb in SQL Server 7.0 (or SQL 2K for that matter...) without stopping and restarting the MSSQLServer service?
TIA, Mike
September 5, 2002 at 10:12 am
I haven't had any success with running dbcc shrinkfile on tempdb. In fact, I would not recommend it as I've run into problems (corruption in tempdb) that have forced me to restart the service anyways.
September 6, 2002 at 5:34 am
I tried this once with a SQL 7 server using the 200 EM client tools to shirnk to a specific size. It worked and I saw no issues but that was a test server with virtually little load. In reviewing SQL determines the best size based on certain criteria. It is not suggested you try to shrink.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply