MS SQL Server - 60 GB tempdb not shrink after sql restarted

Author

60 GB tempdb not shrink after sql restarted

Steve777

2006-02-09, 11:23 am

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,

Uri Dimant

2006-02-10, 3:23 am

Steve
http://www.aspfaq.com/show.asp?id=2446

"Steve777" < Steve777@discussions
.microsoft.com> wrote in message
news:93F053A1-3405-4400-80C6- D8D61E337DFE@microso
ft.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,

Sponsored Links