The shrink file dialogue box indicates the system tempdb has a current size of
1091MB, and a space used of 19MB. I’m assuming I should be able to reduce the
size to 19MB Regardless of what shrink action I invoke it still maintains a size
of 1091MB. Is it possible to reduce the size of this system DB Thanks to everyone
for being there to help.
SQL 2000 SP4
Can't shrink system tempdb
Johnny Bug
HTH;, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---
smaggi
Thanks, that's exactly what I needed. I'm having difficulty finding a link
that demonstrates how to relocate system DB's, like the master DB.
Do you have a link for that also
SQL 2000 SP4
Matt Winkler
Hi, take a look here: http://support.microsoft.com/Default.aspx id=307487
HTH, Jens Suessmeyer.
---
http://www.sqlserver2005.de
---