Sunday, February 19, 2012

60 GB tempdb not shrink after sql restarted

SQL 2000 Enterprise Edition running in active/passive cluster. Restarting SQ
L
server couldn't shrink the huge tempdb. Tried DBCC SHRINKFILE with no luck.
Anyone knows if Method 1 in KB 307487 applies to cluster environment? I am
sure the steps listed in Method 1 works for a stand alone built. What shoudl
I do differently for a cluster?
Thanks,Steve
http://www.aspfaq.com/show.asp?id=2446
"Steve777" <Steve777@.discussions.microsoft.com> wrote in message
news:93F053A1-3405-4400-80C6-D8D61E337DFE@.microsoft.com...
> SQL 2000 Enterprise Edition running in active/passive cluster. Restarting
> SQL
> server couldn't shrink the huge tempdb. Tried DBCC SHRINKFILE with no
> luck.
> Anyone knows if Method 1 in KB 307487 applies to cluster environment? I
> am
> sure the steps listed in Method 1 works for a stand alone built. What
> shoudl
> I do differently for a cluster?
> Thanks,

No comments:

Post a Comment