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
Hi, take a look here: http://support.microsoft.com/Default.aspx?id=307487
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
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
|||Sure, --> http://support.microsoft.com/default.aspx?scid=kb;en-us;224071HTH;, Jens Suessmeyer.
http://www.sqlserver2005.de
