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,
Showing posts with label restarted. Show all posts
Showing posts with label restarted. Show all posts
Sunday, February 19, 2012
60 GB tempdb not shrink after sql restarted
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,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,
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,
Subscribe to:
Posts (Atom)