Hi
I have a 2 node windows 2000 Cluster with a problem. I think the quorum log
became corrupted and now on both nodes the cluster service cannot start.
Without the cluster service running i cannot access any of the resources. On
the event viewer i have some error messages indicating that the quorum log is
corrupted, is there a way of getting the cluster service to start?
I already tried starting the service with the -noquerylogging parameter, the
service started and i could clear the old log from the quorum disk, but after
that i'm trying to restart the service and he just stays on starting state
indefinetly. Is there anything i can do to save my neck...because i noticed a
few minutes ago that bmy backups were not running properly.
Please help me out, i have to start cluster on the next 8 hours!!!!
Thanks a lot
My messenger is f_batista69@.hotmail.com
Hi
Look at
"To recover from a corrupted quorum log or quorum disk"
http://www.microsoft.com/windows2000...luad_pr_70.htm
and
http://support.microsoft.com/default...b;en-us;872970
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"francisco - Portugal" <francisco - Portugal@.discussions.microsoft.com>
wrote in message news:48441502-D241-488E-A26F-CB9E6C1F5FC3@.microsoft.com...
> Hi
> I have a 2 node windows 2000 Cluster with a problem. I think the quorum
> log
> became corrupted and now on both nodes the cluster service cannot start.
> Without the cluster service running i cannot access any of the resources.
> On
> the event viewer i have some error messages indicating that the quorum log
> is
> corrupted, is there a way of getting the cluster service to start?
> I already tried starting the service with the -noquerylogging parameter,
> the
> service started and i could clear the old log from the quorum disk, but
> after
> that i'm trying to restart the service and he just stays on starting state
> indefinetly. Is there anything i can do to save my neck...because i
> noticed a
> few minutes ago that bmy backups were not running properly.
> Please help me out, i have to start cluster on the next 8 hours!!!!
> Thanks a lot
> My messenger is f_batista69@.hotmail.com
>
|||Francisco
Have you tried this.
Power off one of the nodes.
On the remaining NODE start cluster service with -noquorumlogging
Delete Everything inside of the MSCS directory on the Quroum drive (I know
you stated you deleted the quolog.log file previously).
Stop the cluster service and then start it with the -resetquorumlog
If this works then stop the cluster service and start it normally. I have
seen quorum logs become so corrupt that resetquorumlog does not work this
usually fixes it. If this does not work I would recommend the following:
Reboot the only node that is powered up with the cluster service set to
manual.
Go to the command promp c:\Windows\Cluster\clussvc -debug >c:\debug.txt
cut and paste the output into the news groups.
Regards
CT
"francisco - Portugal" wrote:
> Hi
> I have a 2 node windows 2000 Cluster with a problem. I think the quorum log
> became corrupted and now on both nodes the cluster service cannot start.
> Without the cluster service running i cannot access any of the resources. On
> the event viewer i have some error messages indicating that the quorum log is
> corrupted, is there a way of getting the cluster service to start?
> I already tried starting the service with the -noquerylogging parameter, the
> service started and i could clear the old log from the quorum disk, but after
> that i'm trying to restart the service and he just stays on starting state
> indefinetly. Is there anything i can do to save my neck...because i noticed a
> few minutes ago that bmy backups were not running properly.
> Please help me out, i have to start cluster on the next 8 hours!!!!
> Thanks a lot
> My messenger is f_batista69@.hotmail.com
>
sqlsql
Showing posts with label log. Show all posts
Showing posts with label log. Show all posts
Tuesday, March 27, 2012
Sunday, March 25, 2012
Cluster Log error message
Hello to all,
I'm investigating an application outage issue on a 2-node W2K Adv Server
cluster. A Generic Application is running on the cluster in a remote site,
and connects to a UNIX-based Oracle db at my site. There are intermittent
MRxSMB 3019 Event IDs which I'm not too worried about. I just used Q138365
to adjust the autodisconnect value to -1.
But I'm finding this error message in the Cluster log:
Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS PTR
record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status 9005
I can't find anything documented about this error, so I can't tell if this
is something to be concerned about. Is it nothing, a cluster service
problem, DNS registraion problem?
Any thoughts would be greatly appreciated.
Thanks in advance.
Hey I had this error as well when I was setting up my cluster
To fix it:
o Right-click the network connection for your heartbeat adapter, and then
click Properties.
o Click Internet Protocol (TCP/IP), and then click Properties
o On the DNS tab, verify that no values are defined. Make sure that the
Register this connection's address in DNS is cleared.
Hope this helps!!
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:932C28D9-F8C2-4F83-BE57-AA149AF27065@.microsoft.com...
> Hello to all,
> I'm investigating an application outage issue on a 2-node W2K Adv Server
> cluster. A Generic Application is running on the cluster in a remote
site,
> and connects to a UNIX-based Oracle db at my site. There are intermittent
> MRxSMB 3019 Event IDs which I'm not too worried about. I just used
Q138365
> to adjust the autodisconnect value to -1.
> But I'm finding this error message in the Cluster log:
> Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS
PTR
> record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status
9005
> I can't find anything documented about this error, so I can't tell if this
> is something to be concerned about. Is it nothing, a cluster service
> problem, DNS registraion problem?
> Any thoughts would be greatly appreciated.
> Thanks in advance.
sqlsql
I'm investigating an application outage issue on a 2-node W2K Adv Server
cluster. A Generic Application is running on the cluster in a remote site,
and connects to a UNIX-based Oracle db at my site. There are intermittent
MRxSMB 3019 Event IDs which I'm not too worried about. I just used Q138365
to adjust the autodisconnect value to -1.
But I'm finding this error message in the Cluster log:
Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS PTR
record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status 9005
I can't find anything documented about this error, so I can't tell if this
is something to be concerned about. Is it nothing, a cluster service
problem, DNS registraion problem?
Any thoughts would be greatly appreciated.
Thanks in advance.
Hey I had this error as well when I was setting up my cluster
To fix it:
o Right-click the network connection for your heartbeat adapter, and then
click Properties.
o Click Internet Protocol (TCP/IP), and then click Properties
o On the DNS tab, verify that no values are defined. Make sure that the
Register this connection's address in DNS is cleared.
Hope this helps!!
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:932C28D9-F8C2-4F83-BE57-AA149AF27065@.microsoft.com...
> Hello to all,
> I'm investigating an application outage issue on a 2-node W2K Adv Server
> cluster. A Generic Application is running on the cluster in a remote
site,
> and connects to a UNIX-based Oracle db at my site. There are intermittent
> MRxSMB 3019 Event IDs which I'm not too worried about. I just used
Q138365
> to adjust the autodisconnect value to -1.
> But I'm finding this error message in the Cluster log:
> Network Name <Network Name CLUSTER VIRTUAL NAME>: Failed to register DNS
PTR
> record X.X.X.X.in-addr.arpa. for host CLUSTER VIRTUAL NAME FQDN, status
9005
> I can't find anything documented about this error, so I can't tell if this
> is something to be concerned about. Is it nothing, a cluster service
> problem, DNS registraion problem?
> Any thoughts would be greatly appreciated.
> Thanks in advance.
sqlsql
cluster installing
I have installed mscs correctly according the checklist.
But i cannot install sql en server on the cluster.
The attached is the log.
win2k ad sp4/sql en
Thanks
Sanjoy
begin 666 sqlstp.log
M,38Z-3 Z-#0@.0F5G:6X@.4V5T=7 -"C$V.C4P.C0T(#@.N,# N,3DT#0HQ-CHU
M,#HT-"!-;V1E(#T@.3F]R;6%L#0HQ-CHU,#HT-"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,38Z-3 Z-#4@.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'@.P#0HQ-CHU,#HT-2!686QU94944R!R971U<FYE9#H@.,0T*,38Z
M-3 Z-#4@.5F%L=650240@.<F5T=7)N960Z(#$-"C$V.C4P.C0U(%9A;'5E3&EC
M(')E='5R;F5D.B Q#0HQ-CHU,#HT-2!3>7-T96TZ(%=I;F1O=W,@.3E0@.16YT
M97)P<FES92!397)V97(-"C$V.C4P.C0U(%-13"!397)V97(@.4')O9'5C=%1Y
M<&4Z($5N=&5R<')I<V4@.161I=&EO;B!;,'@.S70T*,38Z-3 Z-#4@.27-.5$-L
M=7-T97(@.<F5T=7)N960Z(#$-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.4V5T
M=7!);FET:6%L:7IE( T*,38Z-3 Z-#4@.16YD($%C=&EO;B!3971U<$EN:71I
M86QI>F4-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.(%-E='5P26YS=&%L; T*
M,38Z-3 Z-#4@.4F5A9&EN9R!3;V9T=V%R95Q-:6-R;W-O9G1<5VEN9&]W<UQ#
M=7)R96YT5F5R<VEO;EQ#;VUM;VY&:6QE<T1I<B N+BX-"C$V.C4P.C0U($-O
M;6UO;D9I;&5S1&ER/4,Z7%!R;V=R86T@.1FEL97-<0V]M;6]N($9I;&5S#0HQ
M-CHU,#HT-2!7:6YD;W=S($1I<F5C=&]R>3U#.EQ724Y.5%P-"C$V.C4P.C0U
M(%!R;V=R86T@.1FEL97,]0SI<4')O9W)A;2!&:6QE<UP-"C$V.C4P.C0U(%1%
M35!$25(]0SI<5TE.3E1<5$5-4%P-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.
M(%-E='5P26YS=&%L; T*,38Z-3 Z-#4@.9&EG<&ED('-I>F4@..B R-38-"C$V
M.C4P.C0U(&1I9W!I9"!S:7IE(#H@.,38T#0HQ-CHU,#HT-2!"96=I;B!!8W1I
M;VXZ("!#:&5C:T9I>&5D4F5Q=6ER96UE;G1S#0HQ-CHU,#HT-2!0;&%T9F]R
M;2!)1#H@.,'AF,# P,# -"C$V.C4P.C0U(%9E<G-I;VXZ(#4N,"XR,3DU#0HQ
M-CHU,#HT-2!&:6QE(%9E<G-I;VX@.+2!#.EQ724Y.5%QS>7-T96TS,EQS:&1O
M8W9W+F1L;#H@.-2XP+C,W,# N-C8V. T*,38Z-3 Z-#4@.16YD($%C=&EO;CH@.
M($-H96-K1FEX961297%U:7)E;65N=',-"C$V.C4P.C0U($)E9VEN($%C=&EO
M;CH@.(%-H;W=$:6%L;V=S#0HQ-CHU,#HT-2!);FET:6%L($1I86QO9R!-87-K
M.B P>#$X,S P,&8W+"!$:7-A8FQE($)A8VL],'@.Q#0HQ-CHU,#HT-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$-"C$V.C4P.C0U($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%=E;&-O;64-"C$V.C4P.C0V($5N9"!!
M8W1I;VX@.($1I86QO9U-H;W=39%=E;&-O;64-"C$V.C4P.C0V($1I86QO9R P
M>#$@.<F5T=7)N960Z(#$-"C$V.C4P.C0V($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HQ-CHU,#HT-B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.R+&EN9&5X/3$-"C$V.C4P.C0V($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,@.T*,38Z-3 Z-#8@.0F5G:6X@.06-T:6]N
M.B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$V.C4P.C4S(%-H;W=$;&=-
M86-H:6YE(')E='5R;F5D.B Q#0HQ-CHU,#HU,R!.86UE(#T@.4TY,+"!4>7!E
M(#T@.,'@.Q,# P,# P. T*,38Z-3 Z-3,@.0F5G:6X@.06-T:6]N.B @.0VAE8VM2
M97%U:7)E;65N=',-"C$V.C4P.C4S(%!R;V-E<W-O<B!!<F-H:71E8W1U<F4Z
M('@.X-B H4&5N=&EU;2D-"C$V.C4P.C4S(%-E<G9I8V4@.4&%C:SH@.(#$P,C0-
M"C$V.C4P.C4S($-O;7!U=&5R3F%M93H@.00T*,38Z-3 Z-3,@.57-E<B!.86UE
M.B!A9&UI;FES=')A=&]R#0HQ-CHU,#HU,R!)<T%L;$%C8V5S<T%L;&]W960@.
M<F5T=7)N960Z(#$-"C$V.C4P.C4S($]3($QA;F=U86=E.B P>#@.P- T*,38Z
M-3 Z-3,@.16YD($%C=&EO;B!#:&5C:U)E<75I<F5M96YT<PT*,38Z-3 Z-3,@.
M5&AI<R!C;VUB:6YA=&EO;B!O9B!086-K86=E(&%N9"!/<&5R871I;F<@.4WES
M=&5M(&%L;&]W<R!A(&9U;&P@.<')O9'5C="!I;G-T86QL+@.T*,38Z-3 Z-3,@.
M16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$V.C4P.C4S
M(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3 Z-3,@.;D9U;&Q-
M87-K(#T@.,'@.Q.#,P,#!F-RP@.;D-U<G)E;G0@./2 P>#(L(&Y$:7)E8W1I;VX@.
M/2 P#0HQ-CHU,#HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F,V,P,S<L
M($1I<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3 Z-3,@.1&EA;&]G(#!X,B!R971U
M<FYE9#H@., T*,38Z-3 Z-3,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$V.C4P.C4S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#0L:6YD97@.],@.T*,38Z-3 Z-3,@.0F5G:6X@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<CH@.,'@.T#0HQ-CHU,#HU,R!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V1);G-T86QL36]D90T*,38Z-3 Z-3,@.26YS=&%L;$UO9&4@..B P
M>#$-"C$V.C4P.C4S($5N9"!!8W1I;VX@.($1I86QO9U-H;W=39$EN<W1A;&Q-
M;V1E#0HQ-CHU,#HU,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V
M.C4P.C4S(&Y&=6QL36%S:R ](#!X8F8S8S S-RP@.;D-U<G)E;G0@./2 P>#0L
M(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,#HU,R!5<&1A=&5D($1I86QO9R!-87-K
M.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4P.C4S($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$V.C4P.C4S($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ-CHU,#HU,R!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ-CHU,#HU,R!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ-CHU,#HU,R!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,38Z-3 Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,38Z
M-3 Z-38@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,#HU-B!N
M1G5L;$UA<VL@./2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ-CHU,#HU-B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B
M9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4P.C4V($1I86QO9R P
M>#$P(')E='5R;F5D.B Q#0HQ-CHU,#HU-B!%;F0@.06-T:6]N(%-H;W=$:6%L
M;V=S2&QP<@.T*,38Z-3 Z-38@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N
M960Z(&Y#=7)R96YT/3!X,C L:6YD97@.]-0T*,38Z-3 Z-38@.0F5G:6X@.06-T
M:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.R, T*,38Z-3 Z-38@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D3&EC96YS90T*,38Z-3 Z-3<@.16YD($%C=&EO
M;B!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ-CHU,#HU-R!$:6%L;V<@.,'@.R,"!R
M971U<FYE9#H@.,0T*,38Z-3 Z-3<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL
M<'(-"C$V.C4P.C4W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N
M0W5R<F5N=#TP>#0P,# L:6YD97@.],30-"C$V.C4P.C4W($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P, T*,38Z-3 Z-3<@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D5FER='5A;%-E<G9E<@.T*,38Z-3$Z,C<@.4VAO
M=T1L9U9I<G1U86Q397)V97(@.<F5T=7)N960Z(# -"C$V.C4Q.C(W($EP861D
M<F5S<R ](#$Y,BXQ-C@.N,"XV+#(U-2XR-34N,C4U+C L<'5B;&EC#0HQ-CHU
M,3HR-R!S>DYE=TQI<W0@./2 Q.3(N,38X+C N-BPR-34N,C4U+C(U-2XP+'!U
M8FQI8PT*,38Z-3$Z,C<@.<WI-;V1I9FEE9$QI<W0@./2 -"C$V.C4Q.C(W('-Z
M4F5M;W9E9$QI<W0@./2 -"C$V.C4Q.C(W($5N9"!!8W1I;VX@.($1I86QO9U-H
M;W=39%9I<G1U86Q397)V97(-"C$V.C4Q.C(W(&)E9VEN(%-H;W=$:6%L;V=S
M57!D871E36%S:PT*,38Z-3$Z,C<@.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.
M;D-U<G)E;G0@./2 P>#0P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,3HR-R!5
M<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@.
M/2 P>#$-"C$V.C4Q.C(W($1I86QO9R P>#0P,# @.<F5T=7)N960Z(#$-"C$V
M.C4Q.C(W($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ-CHU,3HR-R!3
M:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.X,# P
M+&EN9&5X/3$U#0HQ-CHU,3HR-R!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R.B P>#@.P,# -"C$V.C4Q.C(W($)E9VEN($%C=&EO;B Z("!$:6%L;V=3
M:&]W4V1$:7-K1W)O=7!S#0HQ-CHU,3HU,"!3:&]W1&QG1&ES:T=R;W5P<R!R
M971U<FYE9#H@.,0T*,38Z-3$Z-3 @.1&ES:R!'<F]U<" ]($1I<VL@.1W)O=7 @.
M,0T*,38Z-3$Z-3 @.16YD($%C=&EO;B Z("!$:6%L;V=3:&]W4V1$:7-K1W)O
M=7!S#0HQ-CHU,3HU,"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V
M.C4Q.C4P(&Y&=6QL36%S:R ](#!X,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3$Z-3 @.57!D871E9"!$:6%L;V<@.
M36%S:SH@.,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,3HU
M,"!$:6%L;V<@.,'@.X,# P(')E='5R;F5D.B Q#0HQ-CHU,3HU,"!%;F0@.06-T
M:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3$Z-3 @.4VAO=T1I86QO9W-'971$
M:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# L:6YD97@.],38-"C$V
M.C4Q.C4P($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# -
M"C$V.C4Q.C4P($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L=7-T97)$
M968-"C$V.C4Q.C4V(%-H;W=$;&=#;'5S=&5R1&5F(')E='5R;F5D.B Q#0HQ
M-CHU,3HU-B!0<F5F3W=N97)S(#T@.02Q"+"!.=6U)<" ](#(-"C$V.C4Q.C4V
M($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C$V.C4Q.C4V
M($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C$V.C4Q.C4V
M($5N9"!!8W1I;VX@..B!686QI9&%T94YO9&5!8W1I;VYS#0HQ-CHU,3HU-B!%
M;F0@.06-T:6]N(#H@.5F%L:61A=&5.;V1E06-T:6]N<PT*,38Z-3$Z-38@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQU<W1E<D1E9@.T*,38Z-3$Z-38@.8F5G
M:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,3HU-B!N1G5L;$UA<VL@.
M/2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# L(&Y$:7)E8W1I;VX@.
M/2 Q#0HQ-CHU,3HU-B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W
M+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4Q.C4V($1I86QO9R P>#$P,# P
M(')E='5R;F5D.B Q#0HQ-CHU,3HU-B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,38Z-3$Z-38@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X,C P,# L:6YD97@.],3<-"C$V.C4Q.C4V($)E9VEN($%C
M=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# -"C$V.C4Q.C4V($)E9VEN
M($%C=&EO;B Z($-L=7-T97(@.4V5C=7)I='D@.+2!$;&=!8V-T#0HQ-CHU,CHQ
M,B!3:&]W1&QG06-C="!R971U<FYE9#H@.,0T*,38Z-3(Z,3(@.6T1L9T%C8V]U
M;G1=#0HQ-CHU,CHQ,B!$;VUA:6X@./2!324Y/3$E.15,-"C$V.C4R.C$R($1O
M;6%I;D%C8W0@./2!!9&UI;FES=')A=&]R#0HQ-CHU,CHQ,B!$;VUA:6Y0=V0-
M"C$V.C4R.C$R(%)E<W5L=" ](#$-"C$V.C4R.C$R($5N9"!!8W1I;VX@..B!#
M;'5S=&5R(%-E8W5R:71Y("T@.1&QG06-C= T*,38Z-3(Z,3(@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,CHQ,B!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X,C P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M-CHU,CHQ,B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C$V.C4R.C$R($1I86QO9R P>#(P,# P(')E='5R
M;F5D.B Q#0HQ-CHU,CHQ,B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*
M,38Z-3(Z,3(@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R
M96YT/3!X-# P,# L:6YD97@.],3@.-"C$V.C4R.C$R($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$V.C4R.C$R($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,38Z-3(Z,3(@.1&ES<&QA>5-Y<W1E
M;5!R95)E<0T*,38Z-3(Z,3(@.4VAO=T1L9T-L:65N=%-E<G9E<E-E;&5C="!R
M971U<FYE9#H@.,0T*,38Z-3(Z,3(@.5'EP92 Z(#!X,@.T*,38Z-3(Z,3(@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R#0HQ-CHU,CHQ,B!B96=I;B!3
M:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V.C4R.C$R(&Y&=6QL36%S:R ](#!X
M,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,"P@.;D1I<F5C=&EO;B ](#$-
M"C$V.C4R.C$R(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)F9F,P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3(Z,3(@.1&EA;&]G(#!X-# P,# @.<F5T
M=7)N960Z(#$-"C$V.C4R.C$R($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ-CHU,CHQ,B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.X,# P,"QI;F1E>#TQ.0T*,38Z-3(Z,3(@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X,# P, T*,38Z-3(Z,3(@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE#0HQ-CHU,CHQ,B!"96=I
M;B!!8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C$V.C4R.C(R($5N9"!!
M8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C$V.C4R.C(R(%-H;W=$;&=)
M;G-T86YC94YA;64@.<F5T=7)N960@..B Q#0HQ-CHU,CHR,B!);G-T86YC94YA
M;64@..B!-4U-13%-%4E9%4@.T*,38Z-3(Z,C0@.0W)E871E4V5T=7!4;W!O;&]G
M>2A33DPI+"!(86YD;&4@..B P>#$Y-S0V93@.L(')E='5R;F5D(#H@., T*,38Z
M-3(Z,C0@.0W)E871E4V5T=7!4;W!O;&]G>2!R971U<FYE9" Z(# L($AA;F1L
M92 Z(#!X,3DW-#9E. T*,38Z-3(Z,C0@.5&]P;VQO9WD@.5'EP92 Z(#,T+"!2
M971U<FX@.5F%L=64@..B P#0HQ-CHU,CHR-"!35%]'9710:'ES:6-A;$YO9&4@.
M<F5T=7)N960@..B P+"!03DAA;F1L92 Z(#!X,3DW-#<Q, T*,38Z-3(Z,C0@.
M4$Y?16YU;65R871E17@.@.<F5T=7)N960@..B P#0HQ-CHU,CHR-"!03E]'9713
M44Q3=&%T97,@.<F5T=7)N960@..B P+"!3<6Q3=&%T97,@..B P># -"C$V.C4R
M.C(T(%!.7U-T87)T4V-A;B!;,'@.Q.3<T-S$P72!R971U<FYE9" Z(# -"C$V
M.C4R.C(T(%!.7T=E=$YE>'0@.6S!X,3DW-#<Q,%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,38Z-3(Z,C0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$V.C4R.C(T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ-CHU
M,CHR-"!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$V
M.C4R.C(T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3(Z,C0@.
M;D9U;&Q-87-K(#T@.,'@.Q8F9F8S S-RP@.;D-U<G)E;G0@./2 P>#@.P,# P+"!N
M1&ER96-T:6]N(#T@.,0T*,38Z-3(Z,C0@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F9F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,CHR-"!$:6%L
M;V<@.,'@.X,# P,"!R971U<FYE9#H@.,0T*,38Z-3(Z,C0@.16YD($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(-"C$V.C4R.C(T(%-H;W=$:6%L;V=S1V5T1&EA;&]G
M(')E='5R;F5D.B!N0W5R<F5N=#TP>#$P,# P,"QI;F1E>#TR, T*,38Z-3(Z
M,C4@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q,# P,# -"C$V
M.C4R.C(U($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39%-E='5P5'EP90T*
M,38Z-3(Z,C4@.0F5G:6X@.06-T:6]N.B!3971U<"!4>7!E#0HQ-CHU,CHS,"!3
M44P@.<')O9W)A;2!F;VQD97(Z($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97(-"C$V.C4R.C,P(%-13"!D871A(&9O;&1E<CH@.6CI<4')O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,38Z-3(Z,S @.5VEN
M9&]W<R!S>7-T96T@.9F]L9&5R.B!#.EQ724Y.5%QS>7-T96TS,EP-"C$V.C4R
M.C,P(%!R;V<@.<F5Q.B S.#(P-2P@.1&%T82!R97$Z(#,V-30T+"!3>7,@.<F5Q
M.B Q.3,U-SD-"C$V.C4R.C,P(%!R;V<@.879A:6PZ(#$W.#,W.3,R+"!$87 1A
M(&%V86EL.B Q-#(Q.#4Q.38L(%-Y<R!A=F%I;#H@.,3<X,S<Y,S(-"C$V.C4R
M.C,P(%!R;V<@.<F5Q('9S+B!A=F%I;"P@.,C,Q-S@.T+" Q-S@.S-SDS,@.T*,38Z
M-3(Z,S @.1&%T82!R97$@.=G,N(&%V86EL+" S-C4T-"P@.,30R,3@.U,3DV#0HQ
M-CHU,CHS,"!3>7,@.<F5Q('9S+B!A=F%I;"P@.,3DS-3<Y+" Q-S@.S-SDS,@.T*
M,38Z-3(Z,S @.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,38Z-3(Z,S @.6U-E='5P
M5'EP95-13%T-"C$V.C4R.C,P('-Z1&ER(#T@.0SI<4')O9W)A;2!&:6QE<UQ-
M:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,38Z-3(Z,S @.<WI$:7(@./2!#.EQ0<F]G
M<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ-CHU,CHS,"!297-U
M;'0@./2 S,#$-"C$V.C4R.C,P('-Z1&%T841I<B ](%HZ7%!R;V=R86T@.1FEL
M97-<36EC<F]S;V9T(%-13"!397)V97(-"C$V.C4R.C,P('-Z1&%T841I<B ]
M(%HZ7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$V.C4R
M.C,P($5N9"!!8W1I;VXZ(%-E='5P(%1Y<&4-"C$V.C4R.C,P(%-E='5P(%1Y
M<&4Z(%1Y<&EC86P@.*#,P,2D-"C$V.C4R.C,P($5N9"!!8W1I;VX@.($1I86QO
M9U-H;W=39%-E='5P5'EP90T*,38Z-3(Z,S @.8F5G:6X@.4VAO=T1I86QO9W-5
M<&1A=&5-87-K#0HQ-CHU,CHS,"!N1G5L;$UA<VL@./2 P>#%B9F9C,#,W+"!N
M0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER96-T:6]N(#T@.,S Q#0HQ-CHU,CHS
M,"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A8FQE($)A
M8VL@./2 P>#$-"C$V.C4R.C,P($1I86QO9R P>#$P,# P,"!R971U<FYE9#H@.
M,S Q#0HQ-CHU,CHS,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z
M-3(Z,S @.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT
M/3!X-# P,# P+&EN9&5X/3(R#0HQ-CHU,CHS,"!"96=I;B!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R.B P>#0P,# P, T*,38Z-3(Z,S @.0F5G:6X@.06-T:6]N
M.B @.1&QG4V5R=FEC97,-"C$V.C4R.C0T(%-H;W=$;&=397)V:6-E<R!R971U
M<FYE9#H@.,0T*,38Z-3(Z-#0@.6T1L9U-E<G9I8V5S70T*,38Z-3(Z-#0@.3&]C
M86PM1&]M86EN"3T@.-C$V.# -"C$V.C4R.C0T($%U=&]3=&%R= D)/2 P#0HQ
M-CHU,CHT-"!344Q$;VUA:6X)"3T@.4TE.3TQ)3D53#0HQ-CHU,CHT-"!344Q$
M;VUA:6Y!8V-T"3T@.061M:6YI<W1R871O<@.T*,38Z-3(Z-#0@.4U%,1&]M86EN
M4'=D#0HQ-CHU,CHT-"!!9W1$;VUA:6X)"3T@.4TE.3TQ)3D53#0HQ-CHU,CHT
M-"!!9W1$;VUA:6Y!8V-T"3T@.061M:6YI<W1R871O<@.T*,38Z-3(Z-#0@.06=T
M1&]M86EN4'=D#0HQ-CHU,CHT-"!297-U;'0)/2 Q#0HQ-CHU,CHT-"!%;F0@.
M06-T:6]N($1L9U-E<G9I8V5S#0HQ-CHU,CHT-"!B96=I;B!3:&]W1&EA;&]G
M<U5P9&%T94UA<VL-"C$V.C4R.C0T(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L
M(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,CHT
M-"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A8FQE($)A
M8VL@./2 P>#$-"C$V.C4R.C0T($1I86QO9R P>#0P,# P,"!R971U<FYE9#H@.
M,0T*,38Z-3(Z-#0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$V.C4R
M.C0U(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP
M>#@.P,# P,"QI;F1E>#TR,PT*,38Z-3(Z-#4@.0F5G:6X@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<CH@.,'@.X,# P,# -"C$V.C4R.C0U($)E9VEN($%C=&EO;CH@.
M($1L9U-13%-E8W5R:71Y#0HQ-CHU,SHP-B!3:&]W1&QG4U%,4V5C=7)I='D@.
M<F5T=7)N960Z(#$-"C$V.C4S.C V($QO9VEN36]D92 ](#(L<WI0=V0-"C$V
M.C4S.C V($5N9"!!8W1I;VX@.1&QG4U%,4V5C=7)I='D-"C$V.C4S.C V(&)E
M9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3,Z,#8@.;D9U;&Q-87-K
M(#T@.,'@.Q8F1F8S S-RP@.;D-U<G)E;G0@./2 P>#@.P,# P,"P@.;D1I<F5C=&EO
M;B ](#$-"C$V.C4S.C V(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)D9F,P
M,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3,Z,#8@.1&EA;&]G(#!X.# P
M,# P(')E='5R;F5D.B Q#0HQ-CHU,SHP-B!%;F0@.06-T:6]N(%-H;W=$:6%L
M;V=S2&QP<@.T*,38Z-3,Z,#8@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N
M960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR- T*,38Z-3,Z,#8@.0F5G
M:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q,# P,# P#0HQ-CHU,SHP
M-B!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-"C$V.C4S.C X(%-H;W=$
M;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$V.C4S.C X(&-O;&QA=&EO;E]N
M86UE(#T@.0VAI;F5S95]04D-?0TE?05,L;&]C86QE7VYA;64@./2!#:&EN97-E
M7U!20RQL8VED(#T@.,'@.X,#0L4V]R=$ED(#T@.,"QD=T-O;7!&;&%G<R ](#!X
M,S P,#$-"C$V.C4S.C X($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ-CHU
M,SHP."!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V.C4S.C X(&Y&
M=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#=7)R96YT(#T@.,'@.Q,# P,# P+"!N
M1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,#@.@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,SHP."!$:6%L
M;V<@.,'@.Q,# P,# P(')E='5R;F5D.B Q#0HQ-CHU,SHP."!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z,#@.@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,C P,# P,"QI;F1E>#TR-0T*,38Z
M-3,Z,#@.@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.R,# P,# P
M#0HQ-CHU,SHP."!"96=I;B!!8W1I;VXZ("!$;&=.971W;W)K#0HQ-CHU,SHP
M."!3:&]W1&QG3F5T=V]R:R!R971U<FYE9#H@.,0T*,38Z-3,Z,#@.@.6T1L9U-E
M<G9E<DYE='=O<FM=#0HQ-CHU,SHP."!.971W;W)K3&EB<R ](#(U-0T*,38Z
M-3,Z,#@.@.5$-04&]R=" ](#$T,S,-"C$V.C4S.C X(%1#4%!R>'D@./2!$969A
M=6QT#0HQ-CHU,SHP."!.35!0:7!E3F%M92 ](%Q<+EQP:7!E7'-Q;%QQ=65R
M>0T*,38Z-3,Z,#@.@.4F5S=6QT(#T@.,0T*,38Z-3,Z,#@.@.16YD($%C=&EO;B!$
M;&=.971W;W)K#0HQ-CHU,SHP."!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA
M<VL-"C$V.C4S.C X(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#=7)R96YT
M(#T@.,'@.R,# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,#@.@.57!D871E
M9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q
M#0HQ-CHU,SHP."!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ-CHU
M,SHP."!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z,#@.@.4VAO
M=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P
M,"QI;F1E>#TR-PT*,38Z-3,Z,#@.@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<CH@.,'@.X,# P,# P#0HQ-CHU,SHP."!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V13=&%R=$-O<'D-"C$V.C4S.C(P($5N9"!!8W1I;VX@.1&EA;&]G
M4VAO=U-D4W1A<G1#;W!Y#0HQ-CHU,SHR,"!B96=I;B!3:&]W1&EA;&]G<U5P
M9&%T94UA<VL-"C$V.C4S.C(P(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#
M=7)R96YT(#T@.,'@.X,# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,C @.
M57!D871E9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K
M(#T@.,'@.Q#0HQ-CHU,SHR,"!$:6%L;V<@.,'@.X,# P,# P(')E='5R;F5D.B Q
M#0HQ-CHU,SHR,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z
M,C @.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X
M,3 P,# P,# L:6YD97@.],C@.-"C$V.C4S.C(P($)E9VEN($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(Z(#!X,3 P,# P,# -"C$V.C4S.C(P($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$QI8V5N<V5-;V1E#0HQ-CHU,SHU-2!3:&]W1&QG
M3&EC96YS92!R971U<FYE9#H@.,0T*,38Z-3,Z-34@.4VAO=T1L9TQI8V5N<V4@.
M<F5T=7)N960Z($QI8V5N<V5-;V1E(#T@.,BP@.3&EC96YS94QI;6ET(#T@.- T*
M,38Z-3,Z-34@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1,:6-E;G-E36]D90T*
M,38Z-3,Z-34@.1&EA;&]G(#!X,3 P,# P,# @.<F5T=7)N960Z(#$-"C$V.C4S
M.C4U($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ-CHU,SHU-2!3:&]W
M1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.P+&EN9&5X
M/3 -"C$V.C4S.C4U($5N9"!!8W1I;VX@.4VAO=T1I86QO9W,-"C$V.C4S.C4U
M(+"RU["SS-#RU?W4VK"RU[ @.36EC<F]S;V9T(+?6LKS*O<K"SO&TIL#MT*VU
M]\;W("A-4T140RD@.+BXN#0HQ-CHU,SHU-2 @.0SI<5TE.3E1<5$5-4%Q3<6Q3
M971U<%Q":6Y<8VQD=&-S=' N97AE("U3=7!P;W)T1&ER(")#.EQ724Y.5%Q4
M14U07%-Q;%-E='5P7$)I;B(@.+4140U!K9R B1#I<>#@.V7$]T:&5R7&1T8W-E
M='5P+F5X92(@.+4QO9T9I;&4@.(D,Z7%=)3DY47'-Q;'-T<"YL;V<B("U#='A!
M8V-T(")324Y/3$E.15-<061M:6YI<W1R871O<B(@.+4-T>$50=V0-"C$V.C4S
M.C4V(%!R;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ-CHU,SHU-B!"96=I;B!!
M8W1I;VX@..B!#;'5S=&5R4V5T=7!(96QP97(-"C$V.C4S.C4V($)E9VEN($%C
M=&EO;B Z($-R96%T94-L=7-T25-31FEL97,-"C$V.C4S.C4V($5N9"!!8W1I
M;VX@..B!#<F5A=&5#;'5S=$E34T9I;&5S#0HQ-CHU,SHU-B!"96=I;B!!8W1I
M;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C$V.C4S.C4V($5N9"!!8W1I;VX@.
M.B!#;'5S=&5R5W)I=&5296U);FD-"C$V.C4S.C4V($)E9VEN($%C=&EO;B Z
M(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO9&5S#0I;87)G<UT-"DYU;5)E;6]T
M95-E<G9E<G,],PT*4V5R=F5R+C,]0@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E
M4V5R=FEC97,],0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE
M>&4-"C$N<V-R:7!T/5Q<05QA9&UI;B1<7TU34U%,4T525D52+FES<PT*,2YC
M;61L:6YE9F]R;6%T/25S(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68Q
M("5S("UO(")S<6QS=' N97AE(B -"C$N=7-E<CU324Y/3$E.15-<061M:6YI
M<W1R871O<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S96%B,V(Q83DU83<U-6$T
M,F-D#0HQ+FYA;64]4U%,4V5T=7 Q#0HQ+G-Q;'-E='5P/5D-"C$N8V]P>65X
M93UC;G9S=F,Q+F5X90T*6U-E<G9E<BXR70T*3G5M4F5M;W1E4V5R=FEC97,]
M,0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE>&4-"C$N<V-R
M:7!T/5Q<05QA9&UI;B1<7TU34U%,4T525D52+FES<PT*,2YC;61L:6Y E9F]R
M;6%T/25S(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68@.(EQ<05Q$)%QX
M.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.)7,@.+68R(")<7%QA9&UI;B1<<V5T
M=7 N;&]G(B M92 B<W1P<VEL;G0N7V5X(B @.+7@.@.(D,Z7"(-"C$N=7-E<CU3
M24Y/3$E.15-<061M:6YI<W1R871O<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S
M96%B,V(Q83DU83<U-6$T,F-D#0HQ+FYA;64]4U%,4V5T=7 R#0HQ+G-Q;'-E
M='5P/5D-"C$N8V]P>65X93UC;G9S=F,R+F5X90T*6U-E<G9E<BXS70T*3G5M
M4F5M;W1E4V5R=FEC97,],0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U
M<'-Q;"YE>&4-"C$N<V5R=F5R/4(-"C$N<V-R:7!T/5Q<05QA9&UI;B1<0E]-
M4U-13%-%4E9%4BYI<W,-"C$N8VUD;&EN969O<FUA=#TE<R!K/4-L4V5C(&L]
M4FT@.:SU#;" M4TU3("US("UF(")<7$%<1"1<>#@.V7'-E='5P7'-E='5P+FEN
M<R(@.+68Q("5S("UF,B B7%Q"7&%D;6EN)%QS971U<"YL;V<B("UE(")S='!S
M:6QN="Y?97@.B(" M>" B0SI<(@.T*,2YU<V5R/5-)3D],24Y%4UQ!9&UI;FES
M=')A=&]R#0HQ+G!A<W-W;W)D/3$S-V,U,F,V,3-E86(S8C%A.35A-S4U830R
M8V0-"C$N;F%M93U344Q3971U<#,-"C$N<W%L<V5T=7 ]60T*,2YC;W!Y97AE
M/6-N=G-V8S,N97AE#0HQ-CHU,SHU-R"PLM>PL\S0\M7]U-K(NKROO=JUX\G/
MUK30T-#HTJJUQ++9U_>AH]7BO\G$W-#HTJK*_;?6UM,N+BX-"C$V.C4S.C4W
M("!#.EQ724Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE>&4@.0SI<
M5TE.3E1<<F5M<V5T=7 N:6YI#0HQ-CHU.#HR,"!0<F]C97-S($5X:70@.0V]D
M93H@.*# I( T*,38Z-3@.Z,C @.0F5G:6X@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2
M971#;V1E#0HQ-CHU.#HR,"!);G-T86QL871I;VX@.<F5T=7)N('-T871U<R!O
M;B @..B M,0T*,38Z-3@.Z,C @.26YS=&%L;&%T:6]N(')E='5R;B!S=&%T=7,@.
M;VX@.(#H@.+3$-"C$V.C4X.C(P($EN<W1A;&QA=&EO;B!R971U<FX@.<W1A=' 5S
M(&]N($(@..B P#0HQ-CHU.#HR,"!%;F0@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2
M971#;V1E#2,C(R,@.4U%,(%-E<G9E<B#4MK/,L++7L+/,T/(@.H:H@.OZK*O,JQ
MO.0@.,#8O,#$O,#0@.,38Z-3,Z-3<@.(R,C(PT*#0K+^<SAN:FUQ,KDR.O6M<[>
MT*>CH0T*#0K+^=*JQ_.UQ++.ROT@.4V5R=F5R+C$@.U-J]VJ.H87)G<Z.IUM##
MN]/0U=*UO:.A#0H-"LOYS.&YJ;7$RN3(Z]:USM[0IZ.A#0H-"LOYTJK'\[7$
MLL[*_2!397)V97(N,B#4VKW:HZAA<F=SHZG6T,.[T]#5TK6]HZ$-"@.T*0U1H
M<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&5(;'!R(&-R96%T92!T:')E860L
M(&EN9&5X/3 -"D-4:')E860Z.E)U;B!T:')E860@.6S!X831=(&-R96%T960@.
M9F]R(&5X96-U=&EO;BX-"D-4:')E860Z.E!R;V-E<W,@.6S!X831=#0I#5&AR
M96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.<W1A<G0@.=&AR96%D( %LP
M>&$T72QI;F1E>#TP#0J]Q;&^SL2\_M+1L\FYIKBTUL:UO:&P7%Q"7$%$34E.
M)%Q"7TU34U%,4T525D52+FES<Z&QUM"AHPT*#0K5_=3:L++7L -2VL\RW_L[Q
MHZA"HZDN+BX-"@.T*U?W4VM3+T-"AL%Q<05Q$)%QX.#9<<V5T=7!<<V5T=7!S
M<6PN97AE(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68@.(EQ<05Q$)%QX
M.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.7%Q"7$%$34E.)%Q"7TU34U%,4T52
M5D52+FES<R M9C(@.(EQ<0EQA9&UI;B1<<V5T=7 N;&]G(B M92 B<W1P<VEL
M;G0N7V5X(B @.+7@.@.(D,Z7"*AL:.H0J.I+BXN#0H-"D-296UO=&50<F]C97-S
M.CI2=6Y5;G1I;$-O;7!L971E(%LP>&$T72!E>&ET(&-O9&4Z(# -"M2VL\R]
M^+/,S<NS]K3ZPNO.JJ&P,*&QHZA"HZFAHPT*#0I#5&AR96%D4&]O;#HZ4G5N
M56YT:6Q#;VUP;&5T94AL<'(@.5V%I=$9O<DUU;'1I<&QE3V)J9 6-T<R!R971U
M<FYE9#H@., T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&5(;'!R('-I
M9VYA;&5D('1H<F5A9"!;,'AA-%T-"E1H<F5A9"!;,'AA-%T@.97AI="!C;V1E
M.B!;,'@.P70T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&4@.<F5T=7)N
M960@., T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&4@.97AE8W5T:6]N
M(&QE=F5L/3$L(&YE960@.97AE8W5T:6]N.B P#0K5_=3:ML^_JM/KU+:SS+S&
MR^.[^J.H0J.IM<3!K+W3+BXN#0H-"M+1L\FYILF^L_VW_L[QH:,-"@.T*TM&S
MR;FFR;ZS_=2VL\S.Q+S^H:,-"@.T*(R,C(R!344P@.4V5R=F5R(-2VL\RPLM>P
ML\S0\B"AJB#-H]:YRK&\Y" P-B\P,2\P-" Q-CHU.#HR," C(R,C#0H-"@.``
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` `````````T*
M,38Z-3@.Z,C @.16YD($%C=&EO;B Z(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO
M9&5S#0HQ-CHU.#HR,"#4VLBZO*^UQ+S&R^.[^LG/U,O0T-2VL\RPLM>PL\S0
M\LJQHZRS]L_6TKNX]KORMN"X]K3MSO.AHPT*,38Z-3@.Z-#(@.L++7L+/,T/+4
MVLBZO*^]VK7CR<_6M-#0TJK'\[7$LMG7]\JGL-RAHPT*,38Z-3@.Z-#(@.0F5G
M:6X@.06-T:6]N(#H@.0VQU<W1E<D5R<F]R0VQE86YU< T*,38Z-3@.Z-#4@.0W)E
M871E4V5T=7!4;W!O;&]G>2A33DPI+"!(86YD;&4@..B P>#$Y-S0V93@.L(')E
M='5R;F5D(#H@., T*,38Z-3@.Z-#4@.0W)E871E4V5T=7!4;W!O;&]G>2!R971U
M<FYE9" Z(# L($AA;F1L92 Z(#!X,3DW-#9E. T*,38Z-3@.Z-#4@.5&]P;VQO
M9WD@.5'EP92 Z(#,T+"!2971U<FX@.5F%L=64@..B P#0HQ-CHU.#HT-2!35%]'
M9710:'ES:6-A;$YO9&4@.<F5T=7)N960@..B P+"!03DAA;F1L92 Z(#!X,3DW
M-#<Q, T*,38Z-3@.Z-#4@.4$Y?16YU;65R871E17@.@.<F5T=7)N960@..B P#0HQ
M-CHU.#HT-2!03E]'971344Q3=&%T97,@.<F5T=7)N960@..B P+"!3<6Q3=&%T
M97,@..B P># -"C$V.C4X.C0U(%!.7T=E=$EN<W1A;F-E(&9O<B!-4U-13%-%
M4E9%4B!;,'@.Q.3<T-S$P72!R971U<FYE9" Z(#$V,#D-"C$V.C4X.C0U(%)E
M;&5A<V53971U<%1O<&]L;V=Y#0I;87)G<UT-"DYU;5)E;6]T95-E<G9E<G,]
M,0T*4V5R=F5R+C$]0@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E4V5R=FEC97,]
M,0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE>&4-"C$N<V5R
M=F5R/4(-"C$N<V-R:7!T/2 -"C$N8VUD;&EN969O<FUA=#TE<R M=2 B0SI<
M5TE.3E1<25-53C X,#0N15A%(B M9B B7%Q"7$,D7%!R;V=R86T@.1FEL97-<
M36EC<F]S;V9T(%-13"!397)V97)<35-344Q<=6YI;G-T+FES=2(@.+4,@.(EQ<
M0EQ#)%Q0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R7$U34U%,
M7'-Q;'-U;BYD;&PB("UM(")-4U-13%-%4E9%4BY-248B("UI($U34U%,4T52
M5D52#0HQ+G5S97(]4TE.3TQ)3D537$%D;6EN:7-T<F%T;W(-"C$N<&%S<W=O
M<F0],3,W8S4R8S8Q,V5A8C-B,6$Y-6$W-35A-#)C9 T*,2YN86UE/5-13%5N
M:6YS=&%L;#$-"C$N<W%L<V5T=7 ]( T*,2YC;W!Y97AE/6-N=G-V8S$N97AE
M#0HQ-CHU.#HT-2"PLM>PL\S0\M7]U-K(NKROO=JUX\G/UK30T,?EL_VRV=?W
MHZRRHL?2TKNUJ<?EL_W-ZK/)OLV]J\W+L_8N+BX-"C$V.C4X.C0U("!#.EQ7
M24Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE>&4@.0SI<5TE.3E1<
M<F5M<V5T=7 N:6YI#0HQ-SHP-#HT,2!0<F]C97-S($5X:70@.0V]D93H@.*#,P
M,3 I(,?KQ_.UQ++9U_>SR;FFH:/6L;6]UMC0PL;TMJ_/M<VSQ["X_+C$O:NR
MN[OAR?K0IZ&C#0H-"C$W.C T.C0Q($)E9VEN($%C=&EO;B Z($=E=%)E;7-E
M='5P4F5T0V]D90T*,3<Z,#0Z-#$@.56YI;G-T86QL('-T871U<R!O;B!"("A-
M4U-13%-%4E9%4BY-248I(#H@.,S Q, T*,3<Z,#0Z-#$@.56YI;G-T86QL(&UE
M<W-A9V4@.;VX@.0B H35-344Q315)615(N34E&*2 Z(%5N:6YS=&%L;"!C;VUP
M;&5T960N("!3;VUE(&5L96UE;G1S(&-O=6QD(&YO="!B92!R96UO=F5D+B @.
M66]U('-H;W5L9"!M86YU86QL>2!R96UO=F4@.:71E;7,@.<F5L871E9"!T; R!T
M:&4@.87!P;&EC871I;VXN#0HQ-SHP-#HT,2!/;F4@.;W(@.;6]R92!N;V1E<R!O
M9B!T:&4@.8VQU<W1E<B!N965D('1O(&)E(')E8F]O=&5D#0HQ-SHP-#HT,2!%
M;F0@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2971#;V1E#2,C(R,@.4U%,(%-E<G9E
M<B#4MK/,L++7L+/,T/(@.H:H@.OZK*O,JQO.0@.,#8O,#$O,#0@.,38Z-3@.Z-#4@.
M(R,C(PT*#0I#5&AR96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.8W)E
M871E('1H<F5A9"P@.:6YD97@.], T*0U1H<F5A9#HZ4G5N('1H<F5A9"!;,'AA
M-%T@.8W)E871E9"!F;W(@.97AE8W5T:6]N+@.T*0U1H<F5A9#HZ4')O8V5S<R!;
M,'AA-%T-"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E2&QP<B!S=&%R
M="!T:')E860@.6S!X831=+&EN9&5X/3 -"M7]U-JPLM>PU+:SS+?^SO&CJ$*C
MJ2XN+@.T*#0K5_=3:U,O0T*&P7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE
M>&4@.+74@.(D,Z7%=)3DY47$E354XP.# T+D5812(@.+68@.(EQ<0EQ#)%Q0<F]G
M<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R7$U34U%,7'5N:6YS="YI
M<W4B("U#(")<7$)<0R1<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ-4U-13%QS<6QS=6XN9&QL(B M;2 B35-344Q315)615(N34E&(B M
M:2!-4U-13%-%4E9%4J&QHZA"HZDN+BX-"@.T*0U)E;6]T95!R;V-E<W,Z.E)U
M;E5N=&EL0V]M<&QE=&4@.6S!X831=(&5X:70@.8V]D93H@.,S Q, T*U+:SS+WX
ML\S-R[/VM/K"Z\ZJH; S,#$PH;&CJ$*CJ:&C#0H-"D-4:')E8610;V]L.CI2
M=6Y5;G1I;$-O;7!L971E2&QP<B!786ET1F]R375L=&EP;&5/8FIE8W1S(')E
M='5R;F5D.B P#0I#5&AR96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.
M<VEG;F%L960@.=&AR96%D(%LP>&$T70T*5&AR96%D(%LP>&$T7 2!E>&ET(&-O
M9&4Z(%LP>&)C,ET-"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E(')E
M='5R;F5D(#,P,3 -"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E(&5X
M96-U=&EO;B!L979E;#TQ+"!N965D(&5X96-U=&EO;CH@., T*U?W4VK;/OZK3
MZ]2VL\R\QLOCN_JCJ$*CJ;7$P:R]TRXN+@.T*#0K2T;/)N:;)OK/]M_[.\:&C
M#0H-"M+1L\FYILF^L_W4MK/,SL2\_J&C#0H-"B,C(R,@.4U%,(%-E<G9E<B#4
MMK/,L++7L+/,T/(@.H:H@.S:/6N<JQO.0@.,#8O,#$O,#0@.,3<Z,#0Z-#$@.(R,C
M(PT*#0H`````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````#0HQ-SHP-#HT,2!%;F0@.
M06-T:6]N(#H@.0VQU<W1E<D5R<F]R0VQE86YU< T*,3<Z,#0Z-#$@.16YD($%C
;=&EO;B Z($-L=7-T97)3971U<$AE;'!E<@.T*
`
end
Can't read some of the log, strangeness. Have you already installed MSDTC in
the cluster? http://support.microsoft.com/default...b;en-us;290624
Any messages that SQL Install gives you would also me nice.
Cheers,
Rod
"Sanjoy Wong" <sanjoy@.sinolines.com> wrote in message
news:OFnTjn7REHA.1036@.TK2MSFTNGP10.phx.gbl...
> I have installed mscs correctly according the checklist.
> But i cannot install sql en server on the cluster.
> The attached is the log.
>
> win2k ad sp4/sql en
> Thanks
> Sanjoy
>
>
|||There should be other sqlstp.logs on the systems. Possibly SQLstp0.log.
Each node should have one. If you can post these we can get a better idea
of what went wrong.
Rand
This posting is provided "as is" with no warranties and confers no rights.
But i cannot install sql en server on the cluster.
The attached is the log.
win2k ad sp4/sql en
Thanks
Sanjoy
begin 666 sqlstp.log
M,38Z-3 Z-#0@.0F5G:6X@.4V5T=7 -"C$V.C4P.C0T(#@.N,# N,3DT#0HQ-CHU
M,#HT-"!-;V1E(#T@.3F]R;6%L#0HQ-CHU,#HT-"!-;V1E5'EP92 ]($Y/4DU!
M3 T*,38Z-3 Z-#4@.1V5T1&5F:6YI=&EO;D5X(')E='5R;F5D.B P+"!%>'1E
M;F1E9#H@.,'@.P#0HQ-CHU,#HT-2!686QU94944R!R971U<FYE9#H@.,0T*,38Z
M-3 Z-#4@.5F%L=650240@.<F5T=7)N960Z(#$-"C$V.C4P.C0U(%9A;'5E3&EC
M(')E='5R;F5D.B Q#0HQ-CHU,#HT-2!3>7-T96TZ(%=I;F1O=W,@.3E0@.16YT
M97)P<FES92!397)V97(-"C$V.C4P.C0U(%-13"!397)V97(@.4')O9'5C=%1Y
M<&4Z($5N=&5R<')I<V4@.161I=&EO;B!;,'@.S70T*,38Z-3 Z-#4@.27-.5$-L
M=7-T97(@.<F5T=7)N960Z(#$-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.4V5T
M=7!);FET:6%L:7IE( T*,38Z-3 Z-#4@.16YD($%C=&EO;B!3971U<$EN:71I
M86QI>F4-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.(%-E='5P26YS=&%L; T*
M,38Z-3 Z-#4@.4F5A9&EN9R!3;V9T=V%R95Q-:6-R;W-O9G1<5VEN9&]W<UQ#
M=7)R96YT5F5R<VEO;EQ#;VUM;VY&:6QE<T1I<B N+BX-"C$V.C4P.C0U($-O
M;6UO;D9I;&5S1&ER/4,Z7%!R;V=R86T@.1FEL97-<0V]M;6]N($9I;&5S#0HQ
M-CHU,#HT-2!7:6YD;W=S($1I<F5C=&]R>3U#.EQ724Y.5%P-"C$V.C4P.C0U
M(%!R;V=R86T@.1FEL97,]0SI<4')O9W)A;2!&:6QE<UP-"C$V.C4P.C0U(%1%
M35!$25(]0SI<5TE.3E1<5$5-4%P-"C$V.C4P.C0U($)E9VEN($%C=&EO;CH@.
M(%-E='5P26YS=&%L; T*,38Z-3 Z-#4@.9&EG<&ED('-I>F4@..B R-38-"C$V
M.C4P.C0U(&1I9W!I9"!S:7IE(#H@.,38T#0HQ-CHU,#HT-2!"96=I;B!!8W1I
M;VXZ("!#:&5C:T9I>&5D4F5Q=6ER96UE;G1S#0HQ-CHU,#HT-2!0;&%T9F]R
M;2!)1#H@.,'AF,# P,# -"C$V.C4P.C0U(%9E<G-I;VXZ(#4N,"XR,3DU#0HQ
M-CHU,#HT-2!&:6QE(%9E<G-I;VX@.+2!#.EQ724Y.5%QS>7-T96TS,EQS:&1O
M8W9W+F1L;#H@.-2XP+C,W,# N-C8V. T*,38Z-3 Z-#4@.16YD($%C=&EO;CH@.
M($-H96-K1FEX961297%U:7)E;65N=',-"C$V.C4P.C0U($)E9VEN($%C=&EO
M;CH@.(%-H;W=$:6%L;V=S#0HQ-CHU,#HT-2!);FET:6%L($1I86QO9R!-87-K
M.B P>#$X,S P,&8W+"!$:7-A8FQE($)A8VL],'@.Q#0HQ-CHU,#HT-2!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$-"C$V.C4P.C0U($)E9VEN
M($%C=&EO;CH@.($1I86QO9U-H;W=39%=E;&-O;64-"C$V.C4P.C0V($5N9"!!
M8W1I;VX@.($1I86QO9U-H;W=39%=E;&-O;64-"C$V.C4P.C0V($1I86QO9R P
M>#$@.<F5T=7)N960Z(#$-"C$V.C4P.C0V($5N9"!!8W1I;VX@.4VAO=T1I86QO
M9W-(;'!R#0HQ-CHU,#HT-B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE
M9#H@.;D-U<G)E;G0],'@.R+&EN9&5X/3$-"C$V.C4P.C0V($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,@.T*,38Z-3 Z-#8@.0F5G:6X@.06-T:6]N
M.B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$V.C4P.C4S(%-H;W=$;&=-
M86-H:6YE(')E='5R;F5D.B Q#0HQ-CHU,#HU,R!.86UE(#T@.4TY,+"!4>7!E
M(#T@.,'@.Q,# P,# P. T*,38Z-3 Z-3,@.0F5G:6X@.06-T:6]N.B @.0VAE8VM2
M97%U:7)E;65N=',-"C$V.C4P.C4S(%!R;V-E<W-O<B!!<F-H:71E8W1U<F4Z
M('@.X-B H4&5N=&EU;2D-"C$V.C4P.C4S(%-E<G9I8V4@.4&%C:SH@.(#$P,C0-
M"C$V.C4P.C4S($-O;7!U=&5R3F%M93H@.00T*,38Z-3 Z-3,@.57-E<B!.86UE
M.B!A9&UI;FES=')A=&]R#0HQ-CHU,#HU,R!)<T%L;$%C8V5S<T%L;&]W960@.
M<F5T=7)N960Z(#$-"C$V.C4P.C4S($]3($QA;F=U86=E.B P>#@.P- T*,38Z
M-3 Z-3,@.16YD($%C=&EO;B!#:&5C:U)E<75I<F5M96YT<PT*,38Z-3 Z-3,@.
M5&AI<R!C;VUB:6YA=&EO;B!O9B!086-K86=E(&%N9"!/<&5R871I;F<@.4WES
M=&5M(&%L;&]W<R!A(&9U;&P@.<')O9'5C="!I;G-T86QL+@.T*,38Z-3 Z-3,@.
M16YD($%C=&EO;B @.1&EA;&]G4VAO=U-D36%C:&EN94YA;64-"C$V.C4P.C4S
M(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3 Z-3,@.;D9U;&Q-
M87-K(#T@.,'@.Q.#,P,#!F-RP@.;D-U<G)E;G0@./2 P>#(L(&Y$:7)E8W1I;VX@.
M/2 P#0HQ-CHU,#HU,R!5<&1A=&5D($1I86QO9R!-87-K.B P>&)F,V,P,S<L
M($1I<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3 Z-3,@.1&EA;&]G(#!X,B!R971U
M<FYE9#H@., T*,38Z-3 Z-3,@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-
M"C$V.C4P.C4S(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R
M<F5N=#TP>#0L:6YD97@.],@.T*,38Z-3 Z-3,@.0F5G:6X@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<CH@.,'@.T#0HQ-CHU,#HU,R!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V1);G-T86QL36]D90T*,38Z-3 Z-3,@.26YS=&%L;$UO9&4@..B P
M>#$-"C$V.C4P.C4S($5N9"!!8W1I;VX@.($1I86QO9U-H;W=39$EN<W1A;&Q-
M;V1E#0HQ-CHU,#HU,R!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V
M.C4P.C4S(&Y&=6QL36%S:R ](#!X8F8S8S S-RP@.;D-U<G)E;G0@./2 P>#0L
M(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,#HU,R!5<&1A=&5D($1I86QO9R!-87-K
M.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4P.C4S($1I
M86QO9R P>#0@.<F5T=7)N960Z(#$-"C$V.C4P.C4S($5N9"!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R#0HQ-CHU,#HU,R!3:&]W1&EA;&]G<T=E=$1I86QO9R!R
M971U<FYE9#H@.;D-U<G)E;G0],'@.Q,"QI;F1E>#TT#0HQ-CHU,#HU,R!"96=I
M;B!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R.B P>#$P#0HQ-CHU,#HU,R!"96=I
M;B!!8W1I;VXZ("!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,38Z-3 Z
M-38@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1296=I<W1E<E5S97)%> T*,38Z
M-3 Z-38@.8F5G:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,#HU-B!N
M1G5L;$UA<VL@./2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 L(&Y$:7)E
M8W1I;VX@./2 Q#0HQ-CHU,#HU-B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B
M9C=C,#,W+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4P.C4V($1I86QO9R P
M>#$P(')E='5R;F5D.B Q#0HQ-CHU,#HU-B!%;F0@.06-T:6]N(%-H;W=$:6%L
M;V=S2&QP<@.T*,38Z-3 Z-38@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N
M960Z(&Y#=7)R96YT/3!X,C L:6YD97@.]-0T*,38Z-3 Z-38@.0F5G:6X@.06-T
M:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.R, T*,38Z-3 Z-38@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D3&EC96YS90T*,38Z-3 Z-3<@.16YD($%C=&EO
M;B!$:6%L;V=3:&]W4V1,:6-E;G-E#0HQ-CHU,#HU-R!$:6%L;V<@.,'@.R,"!R
M971U<FYE9#H@.,0T*,38Z-3 Z-3<@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL
M<'(-"C$V.C4P.C4W(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N
M0W5R<F5N=#TP>#0P,# L:6YD97@.],30-"C$V.C4P.C4W($)E9VEN($%C=&EO
M;B!3:&]W1&EA;&]G<TAL<'(Z(#!X-# P, T*,38Z-3 Z-3<@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D5FER='5A;%-E<G9E<@.T*,38Z-3$Z,C<@.4VAO
M=T1L9U9I<G1U86Q397)V97(@.<F5T=7)N960Z(# -"C$V.C4Q.C(W($EP861D
M<F5S<R ](#$Y,BXQ-C@.N,"XV+#(U-2XR-34N,C4U+C L<'5B;&EC#0HQ-CHU
M,3HR-R!S>DYE=TQI<W0@./2 Q.3(N,38X+C N-BPR-34N,C4U+C(U-2XP+'!U
M8FQI8PT*,38Z-3$Z,C<@.<WI-;V1I9FEE9$QI<W0@./2 -"C$V.C4Q.C(W('-Z
M4F5M;W9E9$QI<W0@./2 -"C$V.C4Q.C(W($5N9"!!8W1I;VX@.($1I86QO9U-H
M;W=39%9I<G1U86Q397)V97(-"C$V.C4Q.C(W(&)E9VEN(%-H;W=$:6%L;V=S
M57!D871E36%S:PT*,38Z-3$Z,C<@.;D9U;&Q-87-K(#T@.,'@.Q8F8W8S S-RP@.
M;D-U<G)E;G0@./2 P>#0P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,3HR-R!5
M<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A8FQE($)A8VL@.
M/2 P>#$-"C$V.C4Q.C(W($1I86QO9R P>#0P,# @.<F5T=7)N960Z(#$-"C$V
M.C4Q.C(W($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ-CHU,3HR-R!3
M:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.X,# P
M+&EN9&5X/3$U#0HQ-CHU,3HR-R!"96=I;B!!8W1I;VX@.4VAO=T1I86QO9W-(
M;'!R.B P>#@.P,# -"C$V.C4Q.C(W($)E9VEN($%C=&EO;B Z("!$:6%L;V=3
M:&]W4V1$:7-K1W)O=7!S#0HQ-CHU,3HU,"!3:&]W1&QG1&ES:T=R;W5P<R!R
M971U<FYE9#H@.,0T*,38Z-3$Z-3 @.1&ES:R!'<F]U<" ]($1I<VL@.1W)O=7 @.
M,0T*,38Z-3$Z-3 @.16YD($%C=&EO;B Z("!$:6%L;V=3:&]W4V1$:7-K1W)O
M=7!S#0HQ-CHU,3HU,"!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V
M.C4Q.C4P(&Y&=6QL36%S:R ](#!X,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.X
M,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3$Z-3 @.57!D871E9"!$:6%L;V<@.
M36%S:SH@.,'@.Q8F8W8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,3HU
M,"!$:6%L;V<@.,'@.X,# P(')E='5R;F5D.B Q#0HQ-CHU,3HU,"!%;F0@.06-T
M:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3$Z-3 @.4VAO=T1I86QO9W-'971$
M:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,3 P,# L:6YD97@.],38-"C$V
M.C4Q.C4P($)E9VEN($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,3 P,# -
M"C$V.C4Q.C4P($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39$-L=7-T97)$
M968-"C$V.C4Q.C4V(%-H;W=$;&=#;'5S=&5R1&5F(')E='5R;F5D.B Q#0HQ
M-CHU,3HU-B!0<F5F3W=N97)S(#T@.02Q"+"!.=6U)<" ](#(-"C$V.C4Q.C4V
M($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C$V.C4Q.C4V
M($)E9VEN($%C=&EO;B Z(%9A;&ED871E3F]D94%C=&EO;G,-"C$V.C4Q.C4V
M($5N9"!!8W1I;VX@..B!686QI9&%T94YO9&5!8W1I;VYS#0HQ-CHU,3HU-B!%
M;F0@.06-T:6]N(#H@.5F%L:61A=&5.;V1E06-T:6]N<PT*,38Z-3$Z-38@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQU<W1E<D1E9@.T*,38Z-3$Z-38@.8F5G
M:6X@.4VAO=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,3HU-B!N1G5L;$UA<VL@.
M/2 P>#%B9C=C,#,W+"!N0W5R<F5N=" ](#!X,3 P,# L(&Y$:7)E8W1I;VX@.
M/2 Q#0HQ-CHU,3HU-B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W
M+"!$:7-A8FQE($)A8VL@./2 P>#$-"C$V.C4Q.C4V($1I86QO9R P>#$P,# P
M(')E='5R;F5D.B Q#0HQ-CHU,3HU-B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<@.T*,38Z-3$Z-38@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z
M(&Y#=7)R96YT/3!X,C P,# L:6YD97@.],3<-"C$V.C4Q.C4V($)E9VEN($%C
M=&EO;B!3:&]W1&EA;&]G<TAL<'(Z(#!X,C P,# -"C$V.C4Q.C4V($)E9VEN
M($%C=&EO;B Z($-L=7-T97(@.4V5C=7)I='D@.+2!$;&=!8V-T#0HQ-CHU,CHQ
M,B!3:&]W1&QG06-C="!R971U<FYE9#H@.,0T*,38Z-3(Z,3(@.6T1L9T%C8V]U
M;G1=#0HQ-CHU,CHQ,B!$;VUA:6X@./2!324Y/3$E.15,-"C$V.C4R.C$R($1O
M;6%I;D%C8W0@./2!!9&UI;FES=')A=&]R#0HQ-CHU,CHQ,B!$;VUA:6Y0=V0-
M"C$V.C4R.C$R(%)E<W5L=" ](#$-"C$V.C4R.C$R($5N9"!!8W1I;VX@..B!#
M;'5S=&5R(%-E8W5R:71Y("T@.1&QG06-C= T*,38Z-3(Z,3(@.8F5G:6X@.4VAO
M=T1I86QO9W-5<&1A=&5-87-K#0HQ-CHU,CHQ,B!N1G5L;$UA<VL@./2 P>#%B
M9C=C,#,W+"!N0W5R<F5N=" ](#!X,C P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ
M-CHU,CHQ,B!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9C=C,#,W+"!$:7-A
M8FQE($)A8VL@./2 P>#$-"C$V.C4R.C$R($1I86QO9R P>#(P,# P(')E='5R
M;F5D.B Q#0HQ-CHU,CHQ,B!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*
M,38Z-3(Z,3(@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R
M96YT/3!X-# P,# L:6YD97@.],3@.-"C$V.C4R.C$R($)E9VEN($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(Z(#!X-# P,# -"C$V.C4R.C$R($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$-L:5-V<@.T*,38Z-3(Z,3(@.1&ES<&QA>5-Y<W1E
M;5!R95)E<0T*,38Z-3(Z,3(@.4VAO=T1L9T-L:65N=%-E<G9E<E-E;&5C="!R
M971U<FYE9#H@.,0T*,38Z-3(Z,3(@.5'EP92 Z(#!X,@.T*,38Z-3(Z,3(@.16YD
M($%C=&EO;B @.1&EA;&]G4VAO=U-D0VQI4W9R#0HQ-CHU,CHQ,B!B96=I;B!3
M:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V.C4R.C$R(&Y&=6QL36%S:R ](#!X
M,6)F-V,P,S<L(&Y#=7)R96YT(#T@.,'@.T,# P,"P@.;D1I<F5C=&EO;B ](#$-
M"C$V.C4R.C$R(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)F9F,P,S<L($1I
M<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3(Z,3(@.1&EA;&]G(#!X-# P,# @.<F5T
M=7)N960Z(#$-"C$V.C4R.C$R($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R
M#0HQ-CHU,CHQ,B!3:&]W1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U
M<G)E;G0],'@.X,# P,"QI;F1E>#TQ.0T*,38Z-3(Z,3(@.0F5G:6X@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<CH@.,'@.X,# P, T*,38Z-3(Z,3(@.0F5G:6X@.06-T
M:6]N.B @.1&EA;&]G4VAO=U-D26YS=&%N8V5.86UE#0HQ-CHU,CHQ,B!"96=I
M;B!!8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C$V.C4R.C(R($5N9"!!
M8W1I;VXZ(%-H;W=$;&=);G-T86YC94YA;64-"C$V.C4R.C(R(%-H;W=$;&=)
M;G-T86YC94YA;64@.<F5T=7)N960@..B Q#0HQ-CHU,CHR,B!);G-T86YC94YA
M;64@..B!-4U-13%-%4E9%4@.T*,38Z-3(Z,C0@.0W)E871E4V5T=7!4;W!O;&]G
M>2A33DPI+"!(86YD;&4@..B P>#$Y-S0V93@.L(')E='5R;F5D(#H@., T*,38Z
M-3(Z,C0@.0W)E871E4V5T=7!4;W!O;&]G>2!R971U<FYE9" Z(# L($AA;F1L
M92 Z(#!X,3DW-#9E. T*,38Z-3(Z,C0@.5&]P;VQO9WD@.5'EP92 Z(#,T+"!2
M971U<FX@.5F%L=64@..B P#0HQ-CHU,CHR-"!35%]'9710:'ES:6-A;$YO9&4@.
M<F5T=7)N960@..B P+"!03DAA;F1L92 Z(#!X,3DW-#<Q, T*,38Z-3(Z,C0@.
M4$Y?16YU;65R871E17@.@.<F5T=7)N960@..B P#0HQ-CHU,CHR-"!03E]'9713
M44Q3=&%T97,@.<F5T=7)N960@..B P+"!3<6Q3=&%T97,@..B P># -"C$V.C4R
M.C(T(%!.7U-T87)T4V-A;B!;,'@.Q.3<T-S$P72!R971U<FYE9" Z(# -"C$V
M.C4R.C(T(%!.7T=E=$YE>'0@.6S!X,3DW-#<Q,%T@.<F5T=7)N960@..B Q."P@.
M2&%N9&QE.B!;,'@.P70T*,38Z-3(Z,C0@.3F\@.;6]R92!I=&5M<R!I;B!E;G5M
M97)A=&EO;BX-"C$V.C4R.C(T(%)E;&5A<V53971U<%1O<&]L;V=Y#0HQ-CHU
M,CHR-"!%;F0@.06-T:6]N("!$:6%L;V=3:&]W4V1);G-T86YC94YA;64-"C$V
M.C4R.C(T(&)E9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3(Z,C0@.
M;D9U;&Q-87-K(#T@.,'@.Q8F9F8S S-RP@.;D-U<G)E;G0@./2 P>#@.P,# P+"!N
M1&ER96-T:6]N(#T@.,0T*,38Z-3(Z,C0@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F9F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,CHR-"!$:6%L
M;V<@.,'@.X,# P,"!R971U<FYE9#H@.,0T*,38Z-3(Z,C0@.16YD($%C=&EO;B!3
M:&]W1&EA;&]G<TAL<'(-"C$V.C4R.C(T(%-H;W=$:6%L;V=S1V5T1&EA;&]G
M(')E='5R;F5D.B!N0W5R<F5N=#TP>#$P,# P,"QI;F1E>#TR, T*,38Z-3(Z
M,C4@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q,# P,# -"C$V
M.C4R.C(U($)E9VEN($%C=&EO;CH@.($1I86QO9U-H;W=39%-E='5P5'EP90T*
M,38Z-3(Z,C4@.0F5G:6X@.06-T:6]N.B!3971U<"!4>7!E#0HQ-CHU,CHS,"!3
M44P@.<')O9W)A;2!F;VQD97(Z($,Z7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T
M(%-13"!397)V97(-"C$V.C4R.C,P(%-13"!D871A(&9O;&1E<CH@.6CI<4')O
M9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,38Z-3(Z,S @.5VEN
M9&]W<R!S>7-T96T@.9F]L9&5R.B!#.EQ724Y.5%QS>7-T96TS,EP-"C$V.C4R
M.C,P(%!R;V<@.<F5Q.B S.#(P-2P@.1&%T82!R97$Z(#,V-30T+"!3>7,@.<F5Q
M.B Q.3,U-SD-"C$V.C4R.C,P(%!R;V<@.879A:6PZ(#$W.#,W.3,R+"!$87 1A
M(&%V86EL.B Q-#(Q.#4Q.38L(%-Y<R!A=F%I;#H@.,3<X,S<Y,S(-"C$V.C4R
M.C,P(%!R;V<@.<F5Q('9S+B!A=F%I;"P@.,C,Q-S@.T+" Q-S@.S-SDS,@.T*,38Z
M-3(Z,S @.1&%T82!R97$@.=G,N(&%V86EL+" S-C4T-"P@.,30R,3@.U,3DV#0HQ
M-CHU,CHS,"!3>7,@.<F5Q('9S+B!A=F%I;"P@.,3DS-3<Y+" Q-S@.S-SDS,@.T*
M,38Z-3(Z,S @.1&ES<&QA>5-Y<W1E;5!R95)E<0T*,38Z-3(Z,S @.6U-E='5P
M5'EP95-13%T-"C$V.C4R.C,P('-Z1&ER(#T@.0SI<4')O9W)A;2!&:6QE<UQ-
M:6-R;W-O9G0@.4U%,(%-E<G9E<@.T*,38Z-3(Z,S @.<WI$:7(@./2!#.EQ0<F]G
M<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R#0HQ-CHU,CHS,"!297-U
M;'0@./2 S,#$-"C$V.C4R.C,P('-Z1&%T841I<B ](%HZ7%!R;V=R86T@.1FEL
M97-<36EC<F]S;V9T(%-13"!397)V97(-"C$V.C4R.C,P('-Z1&%T841I<B ]
M(%HZ7%!R;V=R86T@.1FEL97-<36EC<F]S;V9T(%-13"!397)V97(-"C$V.C4R
M.C,P($5N9"!!8W1I;VXZ(%-E='5P(%1Y<&4-"C$V.C4R.C,P(%-E='5P(%1Y
M<&4Z(%1Y<&EC86P@.*#,P,2D-"C$V.C4R.C,P($5N9"!!8W1I;VX@.($1I86QO
M9U-H;W=39%-E='5P5'EP90T*,38Z-3(Z,S @.8F5G:6X@.4VAO=T1I86QO9W-5
M<&1A=&5-87-K#0HQ-CHU,CHS,"!N1G5L;$UA<VL@./2 P>#%B9F9C,#,W+"!N
M0W5R<F5N=" ](#!X,3 P,# P+"!N1&ER96-T:6]N(#T@.,S Q#0HQ-CHU,CHS
M,"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A8FQE($)A
M8VL@./2 P>#$-"C$V.C4R.C,P($1I86QO9R P>#$P,# P,"!R971U<FYE9#H@.
M,S Q#0HQ-CHU,CHS,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z
M-3(Z,S @.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT
M/3!X-# P,# P+&EN9&5X/3(R#0HQ-CHU,CHS,"!"96=I;B!!8W1I;VX@.4VAO
M=T1I86QO9W-(;'!R.B P>#0P,# P, T*,38Z-3(Z,S @.0F5G:6X@.06-T:6]N
M.B @.1&QG4V5R=FEC97,-"C$V.C4R.C0T(%-H;W=$;&=397)V:6-E<R!R971U
M<FYE9#H@.,0T*,38Z-3(Z-#0@.6T1L9U-E<G9I8V5S70T*,38Z-3(Z-#0@.3&]C
M86PM1&]M86EN"3T@.-C$V.# -"C$V.C4R.C0T($%U=&]3=&%R= D)/2 P#0HQ
M-CHU,CHT-"!344Q$;VUA:6X)"3T@.4TE.3TQ)3D53#0HQ-CHU,CHT-"!344Q$
M;VUA:6Y!8V-T"3T@.061M:6YI<W1R871O<@.T*,38Z-3(Z-#0@.4U%,1&]M86EN
M4'=D#0HQ-CHU,CHT-"!!9W1$;VUA:6X)"3T@.4TE.3TQ)3D53#0HQ-CHU,CHT
M-"!!9W1$;VUA:6Y!8V-T"3T@.061M:6YI<W1R871O<@.T*,38Z-3(Z-#0@.06=T
M1&]M86EN4'=D#0HQ-CHU,CHT-"!297-U;'0)/2 Q#0HQ-CHU,CHT-"!%;F0@.
M06-T:6]N($1L9U-E<G9I8V5S#0HQ-CHU,CHT-"!B96=I;B!3:&]W1&EA;&]G
M<U5P9&%T94UA<VL-"C$V.C4R.C0T(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L
M(&Y#=7)R96YT(#T@.,'@.T,# P,# L(&Y$:7)E8W1I;VX@./2 Q#0HQ-CHU,CHT
M-"!5<&1A=&5D($1I86QO9R!-87-K.B P>#%B9&9C,#,W+"!$:7-A8FQE($)A
M8VL@./2 P>#$-"C$V.C4R.C0T($1I86QO9R P>#0P,# P,"!R971U<FYE9#H@.
M,0T*,38Z-3(Z-#0@.16YD($%C=&EO;B!3:&]W1&EA;&]G<TAL<'(-"C$V.C4R
M.C0U(%-H;W=$:6%L;V=S1V5T1&EA;&]G(')E='5R;F5D.B!N0W5R<F5N=#TP
M>#@.P,# P,"QI;F1E>#TR,PT*,38Z-3(Z-#4@.0F5G:6X@.06-T:6]N(%-H;W=$
M:6%L;V=S2&QP<CH@.,'@.X,# P,# -"C$V.C4R.C0U($)E9VEN($%C=&EO;CH@.
M($1L9U-13%-E8W5R:71Y#0HQ-CHU,SHP-B!3:&]W1&QG4U%,4V5C=7)I='D@.
M<F5T=7)N960Z(#$-"C$V.C4S.C V($QO9VEN36]D92 ](#(L<WI0=V0-"C$V
M.C4S.C V($5N9"!!8W1I;VX@.1&QG4U%,4V5C=7)I='D-"C$V.C4S.C V(&)E
M9VEN(%-H;W=$:6%L;V=S57!D871E36%S:PT*,38Z-3,Z,#8@.;D9U;&Q-87-K
M(#T@.,'@.Q8F1F8S S-RP@.;D-U<G)E;G0@./2 P>#@.P,# P,"P@.;D1I<F5C=&EO
M;B ](#$-"C$V.C4S.C V(%5P9&%T960@.1&EA;&]G($UA<VLZ(#!X,6)D9F,P
M,S<L($1I<V%B;&4@.0F%C:R ](#!X,0T*,38Z-3,Z,#8@.1&EA;&]G(#!X.# P
M,# P(')E='5R;F5D.B Q#0HQ-CHU,SHP-B!%;F0@.06-T:6]N(%-H;W=$:6%L
M;V=S2&QP<@.T*,38Z-3,Z,#8@.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N
M960Z(&Y#=7)R96YT/3!X,3 P,# P,"QI;F1E>#TR- T*,38Z-3,Z,#8@.0F5G
M:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.Q,# P,# P#0HQ-CHU,SHP
M-B!"96=I;B!!8W1I;VXZ("!$;&=#;VQL871I;VX-"C$V.C4S.C X(%-H;W=$
M;&=#;VQL871I;VX@.<F5T=7)N960Z(#$-"C$V.C4S.C X(&-O;&QA=&EO;E]N
M86UE(#T@.0VAI;F5S95]04D-?0TE?05,L;&]C86QE7VYA;64@./2!#:&EN97-E
M7U!20RQL8VED(#T@.,'@.X,#0L4V]R=$ED(#T@.,"QD=T-O;7!&;&%G<R ](#!X
M,S P,#$-"C$V.C4S.C X($5N9"!!8W1I;VX@.1&QG0V]L;&%T:6]N#0HQ-CHU
M,SHP."!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA<VL-"C$V.C4S.C X(&Y&
M=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#=7)R96YT(#T@.,'@.Q,# P,# P+"!N
M1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,#@.@.57!D871E9"!$:6%L;V<@.36%S:SH@.
M,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q#0HQ-CHU,SHP."!$:6%L
M;V<@.,'@.Q,# P,# P(')E='5R;F5D.B Q#0HQ-CHU,SHP."!%;F0@.06-T:6]N
M(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z,#@.@.4VAO=T1I86QO9W-'971$:6%L
M;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X,C P,# P,"QI;F1E>#TR-0T*,38Z
M-3,Z,#@.@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<CH@.,'@.R,# P,# P
M#0HQ-CHU,SHP."!"96=I;B!!8W1I;VXZ("!$;&=.971W;W)K#0HQ-CHU,SHP
M."!3:&]W1&QG3F5T=V]R:R!R971U<FYE9#H@.,0T*,38Z-3,Z,#@.@.6T1L9U-E
M<G9E<DYE='=O<FM=#0HQ-CHU,SHP."!.971W;W)K3&EB<R ](#(U-0T*,38Z
M-3,Z,#@.@.5$-04&]R=" ](#$T,S,-"C$V.C4S.C X(%1#4%!R>'D@./2!$969A
M=6QT#0HQ-CHU,SHP."!.35!0:7!E3F%M92 ](%Q<+EQP:7!E7'-Q;%QQ=65R
M>0T*,38Z-3,Z,#@.@.4F5S=6QT(#T@.,0T*,38Z-3,Z,#@.@.16YD($%C=&EO;B!$
M;&=.971W;W)K#0HQ-CHU,SHP."!B96=I;B!3:&]W1&EA;&]G<U5P9&%T94UA
M<VL-"C$V.C4S.C X(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#=7)R96YT
M(#T@.,'@.R,# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,#@.@.57!D871E
M9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K(#T@.,'@.Q
M#0HQ-CHU,SHP."!$:6%L;V<@.,'@.R,# P,# P(')E='5R;F5D.B Q#0HQ-CHU
M,SHP."!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z,#@.@.4VAO
M=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X.# P,# P
M,"QI;F1E>#TR-PT*,38Z-3,Z,#@.@.0F5G:6X@.06-T:6]N(%-H;W=$:6%L;V=S
M2&QP<CH@.,'@.X,# P,# P#0HQ-CHU,SHP."!"96=I;B!!8W1I;VXZ("!$:6%L
M;V=3:&]W4V13=&%R=$-O<'D-"C$V.C4S.C(P($5N9"!!8W1I;VX@.1&EA;&]G
M4VAO=U-D4W1A<G1#;W!Y#0HQ-CHU,SHR,"!B96=I;B!3:&]W1&EA;&]G<U5P
M9&%T94UA<VL-"C$V.C4S.C(P(&Y&=6QL36%S:R ](#!X,6)D9F,P,S<L(&Y#
M=7)R96YT(#T@.,'@.X,# P,# P+"!N1&ER96-T:6]N(#T@.,0T*,38Z-3,Z,C @.
M57!D871E9"!$:6%L;V<@.36%S:SH@.,'@.Q8F1F8S S-RP@.1&ES86)L92!"86-K
M(#T@.,'@.Q#0HQ-CHU,SHR,"!$:6%L;V<@.,'@.X,# P,# P(')E='5R;F5D.B Q
M#0HQ-CHU,SHR,"!%;F0@.06-T:6]N(%-H;W=$:6%L;V=S2&QP<@.T*,38Z-3,Z
M,C @.4VAO=T1I86QO9W-'971$:6%L;V<@.<F5T=7)N960Z(&Y#=7)R96YT/3!X
M,3 P,# P,# L:6YD97@.],C@.-"C$V.C4S.C(P($)E9VEN($%C=&EO;B!3:&]W
M1&EA;&]G<TAL<'(Z(#!X,3 P,# P,# -"C$V.C4S.C(P($)E9VEN($%C=&EO
M;CH@.($1I86QO9U-H;W=39$QI8V5N<V5-;V1E#0HQ-CHU,SHU-2!3:&]W1&QG
M3&EC96YS92!R971U<FYE9#H@.,0T*,38Z-3,Z-34@.4VAO=T1L9TQI8V5N<V4@.
M<F5T=7)N960Z($QI8V5N<V5-;V1E(#T@.,BP@.3&EC96YS94QI;6ET(#T@.- T*
M,38Z-3,Z-34@.16YD($%C=&EO;B!$:6%L;V=3:&]W4V1,:6-E;G-E36]D90T*
M,38Z-3,Z-34@.1&EA;&]G(#!X,3 P,# P,# @.<F5T=7)N960Z(#$-"C$V.C4S
M.C4U($5N9"!!8W1I;VX@.4VAO=T1I86QO9W-(;'!R#0HQ-CHU,SHU-2!3:&]W
M1&EA;&]G<T=E=$1I86QO9R!R971U<FYE9#H@.;D-U<G)E;G0],'@.P+&EN9&5X
M/3 -"C$V.C4S.C4U($5N9"!!8W1I;VX@.4VAO=T1I86QO9W,-"C$V.C4S.C4U
M(+"RU["SS-#RU?W4VK"RU[ @.36EC<F]S;V9T(+?6LKS*O<K"SO&TIL#MT*VU
M]\;W("A-4T140RD@.+BXN#0HQ-CHU,SHU-2 @.0SI<5TE.3E1<5$5-4%Q3<6Q3
M971U<%Q":6Y<8VQD=&-S=' N97AE("U3=7!P;W)T1&ER(")#.EQ724Y.5%Q4
M14U07%-Q;%-E='5P7$)I;B(@.+4140U!K9R B1#I<>#@.V7$]T:&5R7&1T8W-E
M='5P+F5X92(@.+4QO9T9I;&4@.(D,Z7%=)3DY47'-Q;'-T<"YL;V<B("U#='A!
M8V-T(")324Y/3$E.15-<061M:6YI<W1R871O<B(@.+4-T>$50=V0-"C$V.C4S
M.C4V(%!R;V-E<W,@.17AI="!#;V1E.B H,"D@.#0HQ-CHU,SHU-B!"96=I;B!!
M8W1I;VX@..B!#;'5S=&5R4V5T=7!(96QP97(-"C$V.C4S.C4V($)E9VEN($%C
M=&EO;B Z($-R96%T94-L=7-T25-31FEL97,-"C$V.C4S.C4V($5N9"!!8W1I
M;VX@..B!#<F5A=&5#;'5S=$E34T9I;&5S#0HQ-CHU,SHU-B!"96=I;B!!8W1I
M;VX@..B!#;'5S=&5R5W)I=&5296U);FD-"C$V.C4S.C4V($5N9"!!8W1I;VX@.
M.B!#;'5S=&5R5W)I=&5296U);FD-"C$V.C4S.C4V($)E9VEN($%C=&EO;B Z
M(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO9&5S#0I;87)G<UT-"DYU;5)E;6]T
M95-E<G9E<G,],PT*4V5R=F5R+C,]0@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E
M4V5R=FEC97,],0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE
M>&4-"C$N<V-R:7!T/5Q<05QA9&UI;B1<7TU34U%,4T525D52+FES<PT*,2YC
M;61L:6YE9F]R;6%T/25S(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68Q
M("5S("UO(")S<6QS=' N97AE(B -"C$N=7-E<CU324Y/3$E.15-<061M:6YI
M<W1R871O<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S96%B,V(Q83DU83<U-6$T
M,F-D#0HQ+FYA;64]4U%,4V5T=7 Q#0HQ+G-Q;'-E='5P/5D-"C$N8V]P>65X
M93UC;G9S=F,Q+F5X90T*6U-E<G9E<BXR70T*3G5M4F5M;W1E4V5R=FEC97,]
M,0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE>&4-"C$N<V-R
M:7!T/5Q<05QA9&UI;B1<7TU34U%,4T525D52+FES<PT*,2YC;61L:6Y E9F]R
M;6%T/25S(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68@.(EQ<05Q$)%QX
M.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.)7,@.+68R(")<7%QA9&UI;B1<<V5T
M=7 N;&]G(B M92 B<W1P<VEL;G0N7V5X(B @.+7@.@.(D,Z7"(-"C$N=7-E<CU3
M24Y/3$E.15-<061M:6YI<W1R871O<@.T*,2YP87-S=V]R9#TQ,S=C-3)C-C$S
M96%B,V(Q83DU83<U-6$T,F-D#0HQ+FYA;64]4U%,4V5T=7 R#0HQ+G-Q;'-E
M='5P/5D-"C$N8V]P>65X93UC;G9S=F,R+F5X90T*6U-E<G9E<BXS70T*3G5M
M4F5M;W1E4V5R=FEC97,],0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U
M<'-Q;"YE>&4-"C$N<V5R=F5R/4(-"C$N<V-R:7!T/5Q<05QA9&UI;B1<0E]-
M4U-13%-%4E9%4BYI<W,-"C$N8VUD;&EN969O<FUA=#TE<R!K/4-L4V5C(&L]
M4FT@.:SU#;" M4TU3("US("UF(")<7$%<1"1<>#@.V7'-E='5P7'-E='5P+FEN
M<R(@.+68Q("5S("UF,B B7%Q"7&%D;6EN)%QS971U<"YL;V<B("UE(")S='!S
M:6QN="Y?97@.B(" M>" B0SI<(@.T*,2YU<V5R/5-)3D],24Y%4UQ!9&UI;FES
M=')A=&]R#0HQ+G!A<W-W;W)D/3$S-V,U,F,V,3-E86(S8C%A.35A-S4U830R
M8V0-"C$N;F%M93U344Q3971U<#,-"C$N<W%L<V5T=7 ]60T*,2YC;W!Y97AE
M/6-N=G-V8S,N97AE#0HQ-CHU,SHU-R"PLM>PL\S0\M7]U-K(NKROO=JUX\G/
MUK30T-#HTJJUQ++9U_>AH]7BO\G$W-#HTJK*_;?6UM,N+BX-"C$V.C4S.C4W
M("!#.EQ724Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE>&4@.0SI<
M5TE.3E1<<F5M<V5T=7 N:6YI#0HQ-CHU.#HR,"!0<F]C97-S($5X:70@.0V]D
M93H@.*# I( T*,38Z-3@.Z,C @.0F5G:6X@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2
M971#;V1E#0HQ-CHU.#HR,"!);G-T86QL871I;VX@.<F5T=7)N('-T871U<R!O
M;B @..B M,0T*,38Z-3@.Z,C @.26YS=&%L;&%T:6]N(')E='5R;B!S=&%T=7,@.
M;VX@.(#H@.+3$-"C$V.C4X.C(P($EN<W1A;&QA=&EO;B!R971U<FX@.<W1A=' 5S
M(&]N($(@..B P#0HQ-CHU.#HR,"!%;F0@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2
M971#;V1E#2,C(R,@.4U%,(%-E<G9E<B#4MK/,L++7L+/,T/(@.H:H@.OZK*O,JQ
MO.0@.,#8O,#$O,#0@.,38Z-3,Z-3<@.(R,C(PT*#0K+^<SAN:FUQ,KDR.O6M<[>
MT*>CH0T*#0K+^=*JQ_.UQ++.ROT@.4V5R=F5R+C$@.U-J]VJ.H87)G<Z.IUM##
MN]/0U=*UO:.A#0H-"LOYS.&YJ;7$RN3(Z]:USM[0IZ.A#0H-"LOYTJK'\[7$
MLL[*_2!397)V97(N,B#4VKW:HZAA<F=SHZG6T,.[T]#5TK6]HZ$-"@.T*0U1H
M<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&5(;'!R(&-R96%T92!T:')E860L
M(&EN9&5X/3 -"D-4:')E860Z.E)U;B!T:')E860@.6S!X831=(&-R96%T960@.
M9F]R(&5X96-U=&EO;BX-"D-4:')E860Z.E!R;V-E<W,@.6S!X831=#0I#5&AR
M96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.<W1A<G0@.=&AR96%D( %LP
M>&$T72QI;F1E>#TP#0J]Q;&^SL2\_M+1L\FYIKBTUL:UO:&P7%Q"7$%$34E.
M)%Q"7TU34U%,4T525D52+FES<Z&QUM"AHPT*#0K5_=3:L++7L -2VL\RW_L[Q
MHZA"HZDN+BX-"@.T*U?W4VM3+T-"AL%Q<05Q$)%QX.#9<<V5T=7!<<V5T=7!S
M<6PN97AE(&L]0VQ396,@.:SU2;2!K/4-L("U335,@.+7,@.+68@.(EQ<05Q$)%QX
M.#9<<V5T=7!<<V5T=7 N:6YS(B M9C$@.7%Q"7$%$34E.)%Q"7TU34U%,4T52
M5D52+FES<R M9C(@.(EQ<0EQA9&UI;B1<<V5T=7 N;&]G(B M92 B<W1P<VEL
M;G0N7V5X(B @.+7@.@.(D,Z7"*AL:.H0J.I+BXN#0H-"D-296UO=&50<F]C97-S
M.CI2=6Y5;G1I;$-O;7!L971E(%LP>&$T72!E>&ET(&-O9&4Z(# -"M2VL\R]
M^+/,S<NS]K3ZPNO.JJ&P,*&QHZA"HZFAHPT*#0I#5&AR96%D4&]O;#HZ4G5N
M56YT:6Q#;VUP;&5T94AL<'(@.5V%I=$9O<DUU;'1I<&QE3V)J9 6-T<R!R971U
M<FYE9#H@., T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&5(;'!R('-I
M9VYA;&5D('1H<F5A9"!;,'AA-%T-"E1H<F5A9"!;,'AA-%T@.97AI="!C;V1E
M.B!;,'@.P70T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&4@.<F5T=7)N
M960@., T*0U1H<F5A9%!O;VPZ.E)U;E5N=&EL0V]M<&QE=&4@.97AE8W5T:6]N
M(&QE=F5L/3$L(&YE960@.97AE8W5T:6]N.B P#0K5_=3:ML^_JM/KU+:SS+S&
MR^.[^J.H0J.IM<3!K+W3+BXN#0H-"M+1L\FYILF^L_VW_L[QH:,-"@.T*TM&S
MR;FFR;ZS_=2VL\S.Q+S^H:,-"@.T*(R,C(R!344P@.4V5R=F5R(-2VL\RPLM>P
ML\S0\B"AJB#-H]:YRK&\Y" P-B\P,2\P-" Q-CHU.#HR," C(R,C#0H-"@.``
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` `````````T*
M,38Z-3@.Z,C @.16YD($%C=&EO;B Z(%)U;B!S971U<"!O;B!C;'5S=&5R(&YO
M9&5S#0HQ-CHU.#HR,"#4VLBZO*^UQ+S&R^.[^LG/U,O0T-2VL\RPLM>PL\S0
M\LJQHZRS]L_6TKNX]KORMN"X]K3MSO.AHPT*,38Z-3@.Z-#(@.L++7L+/,T/+4
MVLBZO*^]VK7CR<_6M-#0TJK'\[7$LMG7]\JGL-RAHPT*,38Z-3@.Z-#(@.0F5G
M:6X@.06-T:6]N(#H@.0VQU<W1E<D5R<F]R0VQE86YU< T*,38Z-3@.Z-#4@.0W)E
M871E4V5T=7!4;W!O;&]G>2A33DPI+"!(86YD;&4@..B P>#$Y-S0V93@.L(')E
M='5R;F5D(#H@., T*,38Z-3@.Z-#4@.0W)E871E4V5T=7!4;W!O;&]G>2!R971U
M<FYE9" Z(# L($AA;F1L92 Z(#!X,3DW-#9E. T*,38Z-3@.Z-#4@.5&]P;VQO
M9WD@.5'EP92 Z(#,T+"!2971U<FX@.5F%L=64@..B P#0HQ-CHU.#HT-2!35%]'
M9710:'ES:6-A;$YO9&4@.<F5T=7)N960@..B P+"!03DAA;F1L92 Z(#!X,3DW
M-#<Q, T*,38Z-3@.Z-#4@.4$Y?16YU;65R871E17@.@.<F5T=7)N960@..B P#0HQ
M-CHU.#HT-2!03E]'971344Q3=&%T97,@.<F5T=7)N960@..B P+"!3<6Q3=&%T
M97,@..B P># -"C$V.C4X.C0U(%!.7T=E=$EN<W1A;F-E(&9O<B!-4U-13%-%
M4E9%4B!;,'@.Q.3<T-S$P72!R971U<FYE9" Z(#$V,#D-"C$V.C4X.C0U(%)E
M;&5A<V53971U<%1O<&]L;V=Y#0I;87)G<UT-"DYU;5)E;6]T95-E<G9E<G,]
M,0T*4V5R=F5R+C$]0@.T*6U-E<G9E<BXQ70T*3G5M4F5M;W1E4V5R=FEC97,]
M,0T*,2YA<' ]7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE>&4-"C$N<V5R
M=F5R/4(-"C$N<V-R:7!T/2 -"C$N8VUD;&EN969O<FUA=#TE<R M=2 B0SI<
M5TE.3E1<25-53C X,#0N15A%(B M9B B7%Q"7$,D7%!R;V=R86T@.1FEL97-<
M36EC<F]S;V9T(%-13"!397)V97)<35-344Q<=6YI;G-T+FES=2(@.+4,@.(EQ<
M0EQ#)%Q0<F]G<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R7$U34U%,
M7'-Q;'-U;BYD;&PB("UM(")-4U-13%-%4E9%4BY-248B("UI($U34U%,4T52
M5D52#0HQ+G5S97(]4TE.3TQ)3D537$%D;6EN:7-T<F%T;W(-"C$N<&%S<W=O
M<F0],3,W8S4R8S8Q,V5A8C-B,6$Y-6$W-35A-#)C9 T*,2YN86UE/5-13%5N
M:6YS=&%L;#$-"C$N<W%L<V5T=7 ]( T*,2YC;W!Y97AE/6-N=G-V8S$N97AE
M#0HQ-CHU.#HT-2"PLM>PL\S0\M7]U-K(NKROO=JUX\G/UK30T,?EL_VRV=?W
MHZRRHL?2TKNUJ<?EL_W-ZK/)OLV]J\W+L_8N+BX-"C$V.C4X.C0U("!#.EQ7
M24Y.5%Q414U07%-Q;%-E='5P7$)I;EQR96US971U<"YE>&4@.0SI<5TE.3E1<
M<F5M<V5T=7 N:6YI#0HQ-SHP-#HT,2!0<F]C97-S($5X:70@.0V]D93H@.*#,P
M,3 I(,?KQ_.UQ++9U_>SR;FFH:/6L;6]UMC0PL;TMJ_/M<VSQ["X_+C$O:NR
MN[OAR?K0IZ&C#0H-"C$W.C T.C0Q($)E9VEN($%C=&EO;B Z($=E=%)E;7-E
M='5P4F5T0V]D90T*,3<Z,#0Z-#$@.56YI;G-T86QL('-T871U<R!O;B!"("A-
M4U-13%-%4E9%4BY-248I(#H@.,S Q, T*,3<Z,#0Z-#$@.56YI;G-T86QL(&UE
M<W-A9V4@.;VX@.0B H35-344Q315)615(N34E&*2 Z(%5N:6YS=&%L;"!C;VUP
M;&5T960N("!3;VUE(&5L96UE;G1S(&-O=6QD(&YO="!B92!R96UO=F5D+B @.
M66]U('-H;W5L9"!M86YU86QL>2!R96UO=F4@.:71E;7,@.<F5L871E9"!T; R!T
M:&4@.87!P;&EC871I;VXN#0HQ-SHP-#HT,2!/;F4@.;W(@.;6]R92!N;V1E<R!O
M9B!T:&4@.8VQU<W1E<B!N965D('1O(&)E(')E8F]O=&5D#0HQ-SHP-#HT,2!%
M;F0@.06-T:6]N(#H@.1V5T4F5M<V5T=7!2971#;V1E#2,C(R,@.4U%,(%-E<G9E
M<B#4MK/,L++7L+/,T/(@.H:H@.OZK*O,JQO.0@.,#8O,#$O,#0@.,38Z-3@.Z-#4@.
M(R,C(PT*#0I#5&AR96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.8W)E
M871E('1H<F5A9"P@.:6YD97@.], T*0U1H<F5A9#HZ4G5N('1H<F5A9"!;,'AA
M-%T@.8W)E871E9"!F;W(@.97AE8W5T:6]N+@.T*0U1H<F5A9#HZ4')O8V5S<R!;
M,'AA-%T-"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E2&QP<B!S=&%R
M="!T:')E860@.6S!X831=+&EN9&5X/3 -"M7]U-JPLM>PU+:SS+?^SO&CJ$*C
MJ2XN+@.T*#0K5_=3:U,O0T*&P7%Q!7$0D7'@.X-EQS971U<%QS971U<'-Q;"YE
M>&4@.+74@.(D,Z7%=)3DY47$E354XP.# T+D5812(@.+68@.(EQ<0EQ#)%Q0<F]G
M<F%M($9I;&5S7$UI8W)O<V]F="!344P@.4V5R=F5R7$U34U%,7'5N:6YS="YI
M<W4B("U#(")<7$)<0R1<4')O9W)A;2!&:6QE<UQ-:6-R;W-O9G0@.4U%,(%-E
M<G9E<EQ-4U-13%QS<6QS=6XN9&QL(B M;2 B35-344Q315)615(N34E&(B M
M:2!-4U-13%-%4E9%4J&QHZA"HZDN+BX-"@.T*0U)E;6]T95!R;V-E<W,Z.E)U
M;E5N=&EL0V]M<&QE=&4@.6S!X831=(&5X:70@.8V]D93H@.,S Q, T*U+:SS+WX
ML\S-R[/VM/K"Z\ZJH; S,#$PH;&CJ$*CJ:&C#0H-"D-4:')E8610;V]L.CI2
M=6Y5;G1I;$-O;7!L971E2&QP<B!786ET1F]R375L=&EP;&5/8FIE8W1S(')E
M='5R;F5D.B P#0I#5&AR96%D4&]O;#HZ4G5N56YT:6Q#;VUP;&5T94AL<'(@.
M<VEG;F%L960@.=&AR96%D(%LP>&$T70T*5&AR96%D(%LP>&$T7 2!E>&ET(&-O
M9&4Z(%LP>&)C,ET-"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E(')E
M='5R;F5D(#,P,3 -"D-4:')E8610;V]L.CI2=6Y5;G1I;$-O;7!L971E(&5X
M96-U=&EO;B!L979E;#TQ+"!N965D(&5X96-U=&EO;CH@., T*U?W4VK;/OZK3
MZ]2VL\R\QLOCN_JCJ$*CJ;7$P:R]TRXN+@.T*#0K2T;/)N:;)OK/]M_[.\:&C
M#0H-"M+1L\FYILF^L_W4MK/,SL2\_J&C#0H-"B,C(R,@.4U%,(%-E<G9E<B#4
MMK/,L++7L+/,T/(@.H:H@.S:/6N<JQO.0@.,#8O,#$O,#0@.,3<Z,#0Z-#$@.(R,C
M(PT*#0H`````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````#0HQ-SHP-#HT,2!%;F0@.
M06-T:6]N(#H@.0VQU<W1E<D5R<F]R0VQE86YU< T*,3<Z,#0Z-#$@.16YD($%C
;=&EO;B Z($-L=7-T97)3971U<$AE;'!E<@.T*
`
end
Can't read some of the log, strangeness. Have you already installed MSDTC in
the cluster? http://support.microsoft.com/default...b;en-us;290624
Any messages that SQL Install gives you would also me nice.
Cheers,
Rod
"Sanjoy Wong" <sanjoy@.sinolines.com> wrote in message
news:OFnTjn7REHA.1036@.TK2MSFTNGP10.phx.gbl...
> I have installed mscs correctly according the checklist.
> But i cannot install sql en server on the cluster.
> The attached is the log.
>
> win2k ad sp4/sql en
> Thanks
> Sanjoy
>
>
|||There should be other sqlstp.logs on the systems. Possibly SQLstp0.log.
Each node should have one. If you can post these we can get a better idea
of what went wrong.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Thursday, March 22, 2012
Cluster install failing
When installing SQL 2005 on a 2 node cluster, the install fails saying setup
on the remote machine failed, check the task scheduler log. The log on the
remote machine says "Unable to start task...Access is denied". Any idea how
to get around this?
Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
I also need to mention that I have Act as part of the operating system and
log on as a service rights on both nodes.
"Brad" wrote:
> When installing SQL 2005 on a 2 node cluster, the install fails saying setup
> on the remote machine failed, check the task scheduler log. The log on the
> remote machine says "Unable to start task...Access is denied". Any idea how
> to get around this?
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
|||You have to install using a domain account that is a member of the local
administrators group on each server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:AA1196F9-0113-4844-B2C4-1BEABCAE97F3@.microsoft.com...[vbcol=seagreen]
>I also need to mention that I have Act as part of the operating system and
> log on as a service rights on both nodes.
> "Brad" wrote:
|||Permissions. The account that you are using to install the failover cluster
instance must be a member of the local admin group on each machine. (The
service accounts related to SQL Server do NOT need to be.)
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:F9ED4AEF-08EF-40CD-845E-E86794714C8A@.microsoft.com...
> When installing SQL 2005 on a 2 node cluster, the install fails saying
> setup
> on the remote machine failed, check the task scheduler log. The log on
> the
> remote machine says "Unable to start task...Access is denied". Any idea
> how
> to get around this?
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
|||Yes, thank you. The domain account I am using is already a member of the
admin group on both nodes. The error still persists.
"Geoff N. Hiten" wrote:
> You have to install using a domain account that is a member of the local
> administrators group on each server.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:AA1196F9-0113-4844-B2C4-1BEABCAE97F3@.microsoft.com...
>
>
|||I didn't provide that information up front but the account is a member of the
admin group on both boxes.
"Michael Hotek" wrote:
> Permissions. The account that you are using to install the failover cluster
> instance must be a member of the local admin group on each machine. (The
> service accounts related to SQL Server do NOT need to be.)
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:F9ED4AEF-08EF-40CD-845E-E86794714C8A@.microsoft.com...
>
>
|||Hi,
But is it the LOCAL ADMIN ACCOUNT not domain admin account?
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:56372080-3701-40DA-8CF1-9B002BDC2E11@.microsoft.com...[vbcol=seagreen]
> Yes, thank you. The domain account I am using is already a member of the
> admin group on both nodes. The error still persists.
> "Geoff N. Hiten" wrote:
|||Yes, it is in the local admin group on both machines.
"Nik Marshall-Blank" wrote:
> Hi,
> But is it the LOCAL ADMIN ACCOUNT not domain admin account?
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:56372080-3701-40DA-8CF1-9B002BDC2E11@.microsoft.com...
>
>
|||Make sure the task scheduler service is enabled and running on all nodes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:DC6D365B-B9E9-4A59-947C-0A947C91826B@.microsoft.com...[vbcol=seagreen]
> Yes, it is in the local admin group on both machines.
> "Nik Marshall-Blank" wrote:
|||Did you ever get a resolution on this ? I am having the exact same
problem.
I have checked all the obvious problems, like permissions, task
scheduler service running, etc.
I am going to call Microsoft Support tomorrow if I can't figure this
out.
Brad wrote:[vbcol=seagreen]
> I didn't provide that information up front but the account is a member of the
> admin group on both boxes.
> "Michael Hotek" wrote:
sqlsql
on the remote machine failed, check the task scheduler log. The log on the
remote machine says "Unable to start task...Access is denied". Any idea how
to get around this?
Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
I also need to mention that I have Act as part of the operating system and
log on as a service rights on both nodes.
"Brad" wrote:
> When installing SQL 2005 on a 2 node cluster, the install fails saying setup
> on the remote machine failed, check the task scheduler log. The log on the
> remote machine says "Unable to start task...Access is denied". Any idea how
> to get around this?
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
|||You have to install using a domain account that is a member of the local
administrators group on each server.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:AA1196F9-0113-4844-B2C4-1BEABCAE97F3@.microsoft.com...[vbcol=seagreen]
>I also need to mention that I have Act as part of the operating system and
> log on as a service rights on both nodes.
> "Brad" wrote:
|||Permissions. The account that you are using to install the failover cluster
instance must be a member of the local admin group on each machine. (The
service accounts related to SQL Server do NOT need to be.)
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:F9ED4AEF-08EF-40CD-845E-E86794714C8A@.microsoft.com...
> When installing SQL 2005 on a 2 node cluster, the install fails saying
> setup
> on the remote machine failed, check the task scheduler log. The log on
> the
> remote machine says "Unable to start task...Access is denied". Any idea
> how
> to get around this?
> Environment is DL585, Windows 2003 x64 sp1, SQL 2005 x64 Dev Edition
|||Yes, thank you. The domain account I am using is already a member of the
admin group on both nodes. The error still persists.
"Geoff N. Hiten" wrote:
> You have to install using a domain account that is a member of the local
> administrators group on each server.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:AA1196F9-0113-4844-B2C4-1BEABCAE97F3@.microsoft.com...
>
>
|||I didn't provide that information up front but the account is a member of the
admin group on both boxes.
"Michael Hotek" wrote:
> Permissions. The account that you are using to install the failover cluster
> instance must be a member of the local admin group on each machine. (The
> service accounts related to SQL Server do NOT need to be.)
> --
> Mike
> http://www.solidqualitylearning.com
> Disclaimer: This communication is an original work and represents my sole
> views on the subject. It does not represent the views of any other person
> or entity either by inference or direct reference.
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:F9ED4AEF-08EF-40CD-845E-E86794714C8A@.microsoft.com...
>
>
|||Hi,
But is it the LOCAL ADMIN ACCOUNT not domain admin account?
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:56372080-3701-40DA-8CF1-9B002BDC2E11@.microsoft.com...[vbcol=seagreen]
> Yes, thank you. The domain account I am using is already a member of the
> admin group on both nodes. The error still persists.
> "Geoff N. Hiten" wrote:
|||Yes, it is in the local admin group on both machines.
"Nik Marshall-Blank" wrote:
> Hi,
> But is it the LOCAL ADMIN ACCOUNT not domain admin account?
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Brad" <Brad@.discussions.microsoft.com> wrote in message
> news:56372080-3701-40DA-8CF1-9B002BDC2E11@.microsoft.com...
>
>
|||Make sure the task scheduler service is enabled and running on all nodes.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:DC6D365B-B9E9-4A59-947C-0A947C91826B@.microsoft.com...[vbcol=seagreen]
> Yes, it is in the local admin group on both machines.
> "Nik Marshall-Blank" wrote:
|||Did you ever get a resolution on this ? I am having the exact same
problem.
I have checked all the obvious problems, like permissions, task
scheduler service running, etc.
I am going to call Microsoft Support tomorrow if I can't figure this
out.
Brad wrote:[vbcol=seagreen]
> I didn't provide that information up front but the account is a member of the
> admin group on both boxes.
> "Michael Hotek" wrote:
sqlsql
Tuesday, March 20, 2012
cluster error
We have a one node cluster that is receiving the below error messages in the cluster.log and the Event Viewer. In the SQL Server 2005 SP2 job that fails we receive a slighlty different message. The OS is Windows 2003 SP1. This is not a 64-bit box. We have checked the permissions of the cluster service account in SQL Server to be sure they are correct. Can anyone please help with this issue.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: QP is not online.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
Moved to High Availablity forum...
(Please do not 'cluster' bomb so many forums with the same posting. Pick one, and give it time.)
|||What type of server (HP, Dell)?|||Anyone have any Ideas on this. I am having the same problem.cluster error
We have a one node cluster that is receiving the below error messages in the cluster.log and the Event Viewer. In the SQL Server 2005 SP2 job that fails we receive a slighlty different message. The OS is Windows 2003 SP1. This is not a 64-bit box. We have checked the permissions of the cluster service account in SQL Server to be sure they are correct. Can anyone please help with this issue.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] OnlineThread: QP is not online.
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
00000a0c.0000089c::2007/06/12-12:51:27.459 ERR SQL Server <SQL Server>: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure
Moved to High Availablity forum...
(Please do not 'cluster' bomb so many forums with the same posting. Pick one, and give it time.)
|||What type of server (HP, Dell)?|||Anyone have any Ideas on this. I am having the same problem.Cluster Environment SQL Server setup and configure
What is the best way to setup and configure a clusterd
environment of SQL Server in terms of RAID, data file
location, log file location, backup etc. I guess in
separate drives for data and logfile.Great question. The bad answer is always "it depends."
You must be doing something like a SAN or DAS right? In very general terms,
split the data, logs, and temp db all out on different raid configs, i.e.,
LUNs. I like RAID 1+0 (or said RAID 10) because of the speed and high
tolerance of multiple disk failures at once, not to mention when you need
more disk space, adding new spindles is easy. If performance is more
important than money, then spread out over as many spindles as feasable.
You achieve more I/Os this way. This means, go for more disks of lower size
than few disks of higher size.
I believe on the SQL disk there is a VB6 application called database hammer
which you can use to test your config.
hth, Eric
"Aboki" <waco361@.hotmail.com> wrote in message
news:0afe01c36b38$2ab80730$a001280a@.phx.gbl...
> What is the best way to setup and configure a clusterd
> environment of SQL Server in terms of RAID, data file
> location, log file location, backup etc. I guess in
> separate drives for data and logfile.sqlsql
environment of SQL Server in terms of RAID, data file
location, log file location, backup etc. I guess in
separate drives for data and logfile.Great question. The bad answer is always "it depends."
You must be doing something like a SAN or DAS right? In very general terms,
split the data, logs, and temp db all out on different raid configs, i.e.,
LUNs. I like RAID 1+0 (or said RAID 10) because of the speed and high
tolerance of multiple disk failures at once, not to mention when you need
more disk space, adding new spindles is easy. If performance is more
important than money, then spread out over as many spindles as feasable.
You achieve more I/Os this way. This means, go for more disks of lower size
than few disks of higher size.
I believe on the SQL disk there is a VB6 application called database hammer
which you can use to test your config.
hth, Eric
"Aboki" <waco361@.hotmail.com> wrote in message
news:0afe01c36b38$2ab80730$a001280a@.phx.gbl...
> What is the best way to setup and configure a clusterd
> environment of SQL Server in terms of RAID, data file
> location, log file location, backup etc. I guess in
> separate drives for data and logfile.sqlsql
Monday, March 19, 2012
cluster ? on muliple data disks
Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?
The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?
|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resources
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Service
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?
The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?
|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resources
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Service
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>
cluster ? on muliple data disks
Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resources
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Service
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> > Hi,
> > I have setup a 2 node a/p cluster. During install i picked the s drive as
> > the data drive, and the L drive as the log drive.
> > i was able to create a db on the S drive
> > now i want to create a database and use the z drive. but it won't show me
> > the Z drive as a option when i try to browse to a different drive as part
> > of
> > the create new db steps.
> >
> > both disks are disk resources managed by the cluster
> >
> > in the past, i have been able to do it on a non clustered server
> >
> > what is the trick with a cluster?
>
>
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resources
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Service
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> > Hi,
> > I have setup a 2 node a/p cluster. During install i picked the s drive as
> > the data drive, and the L drive as the log drive.
> > i was able to create a db on the S drive
> > now i want to create a database and use the z drive. but it won't show me
> > the Z drive as a option when i try to browse to a different drive as part
> > of
> > the create new db steps.
> >
> > both disks are disk resources managed by the cluster
> >
> > in the past, i have been able to do it on a non clustered server
> >
> > what is the trick with a cluster?
>
>
cluster ? on muliple data disks
Hi,
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resourc
es
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Servi
ce
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>
I have setup a 2 node a/p cluster. During install i picked the s drive as
the data drive, and the L drive as the log drive.
i was able to create a db on the S drive
now i want to create a database and use the z drive. but it won't show me
the Z drive as a option when i try to browse to a different drive as part of
the create new db steps.
both disks are disk resources managed by the cluster
in the past, i have been able to do it on a non clustered server
what is the trick with a cluster?The "trick" is twofold. First, you have to make the disks Cluster Resources
and put them in the resource group for the SQL virtual server. I am
guessing this is where you are at. Second, you have to make the SQL Service
dependent on the disk resource. You will have to take the service offline
to make the change. Look at the dependency relationship between the SQL
service and the existing disk resources.
Geoff N. Hiten
Microsoft SQL Server MVP
"jason" <jason@.discussions.microsoft.com> wrote in message
news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
> Hi,
> I have setup a 2 node a/p cluster. During install i picked the s drive as
> the data drive, and the L drive as the log drive.
> i was able to create a db on the S drive
> now i want to create a database and use the z drive. but it won't show me
> the Z drive as a option when i try to browse to a different drive as part
> of
> the create new db steps.
> both disks are disk resources managed by the cluster
> in the past, i have been able to do it on a non clustered server
> what is the trick with a cluster?|||Geoff, that did it thanks!
"Geoff N. Hiten" wrote:
> The "trick" is twofold. First, you have to make the disks Cluster Resourc
es
> and put them in the resource group for the SQL virtual server. I am
> guessing this is where you are at. Second, you have to make the SQL Servi
ce
> dependent on the disk resource. You will have to take the service offline
> to make the change. Look at the dependency relationship between the SQL
> service and the existing disk resources.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "jason" <jason@.discussions.microsoft.com> wrote in message
> news:FA7F35A5-7EDE-4162-90CE-E6AAD7D43057@.microsoft.com...
>
>
Wednesday, March 7, 2012
closing SQL Connection
hello to all
i am finding my self in confusing problem.
everyay log file of my application increase by 10 GB.
every time i found more than 100 connections open in SDQL Server 2005 under my database.
i an using SQLHELPER Class by microsoft.i ma not putting my code in try-catch block. example
of one of my frequently used function is as follows:
protected Int64 GetMemberID()
{
String SqlSelect = "SELECT * FROM MemberMaster WHERE MemberUserName= '" +
Session["UserName"].ToString() + "'";
SqlDataReader dr1 =
SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["CowcallConnectionString2"].T
oString(), CommandType.Text, SqlSelect);
while (dr1.Read())
{
CurrentMemberID = Int64.Parse(dr1["MemberID"].ToString().Trim());
}
return CurrentMemberID;
}
well i doubt i am opening connection and do not closing it. moreover i do not know how to close connection in above code when i am using sql helper class.
please give me yours suggestion regarding my code even if it is not solving above two problems.
Hi munishbhatia,
use theCommandBehavior to close the connection after use like: SqlHelper.ExecuteReader(CommandBehavior.CloseConnection);
Closed transaction keeps running...awaiting command
I am debugging an app which blocks many processes in a SQL7 server DB.
The app log writes every transaction "open" and "close".
The weird thing is : when the app logfile says the transaction is
dropped (object closed) the db keeps showing the process "running", in
a sleeping mode, with open_tran in 2 or even 3 and in an awaiting
command status.
The app log writes every transaction "open" and "close".
The weird thing is : when the app logfile says the transaction is
dropped (object closed) the db keeps showing the process "running", in
a sleeping mode, with open_tran in 2 or even 3 and in an awaiting
command status.
We are working on NT4.0, SP6a (all fixes up to date, MDAC 2.7SP1) on
IIS side, an equal box for MTS (same patches and updates) and a SQL
Server 7 (on NT4, same fixes ans SPs) database on another box.
Is this normal? Those sleeping processes are blocking other apps and
everything gets slow and messy...the only solution is to kill those
blocking processes.
Thanks![posted and mailed, please reply in news]
Rittercorp (ritter_cl@.yahoo.com) writes:
> I am debugging an app which blocks many processes in a SQL7 server DB.
> The app log writes every transaction "open" and "close".
> The weird thing is : when the app logfile says the transaction is
> dropped (object closed) the db keeps showing the process "running", in
> a sleeping mode, with open_tran in 2 or even 3 and in an awaiting
> command status.
> We are working on NT4.0, SP6a (all fixes up to date, MDAC 2.7SP1) on
> IIS side, an equal box for MTS (same patches and updates) and a SQL
> Server 7 (on NT4, same fixes ans SPs) database on another box.
> Is this normal? Those sleeping processes are blocking other apps and
> everything gets slow and messy...the only solution is to kill those
> blocking processes.
No, this is not normal. Apparently your application has a problem with
transaction scope. The fact that your application log looks good proves
little. The application log may know about transaction it starts, but
what about transactions that starts in SQL code, for instance in
stored procedures?
There are a couple of gotchas. For instance, if you call a stored procedure
and that stored procedure starts a transaction, but the application
cancels the procedure before the execution completed, for instance
because of the dreaded "Timeout expired", the transaction started by
the SP is *not* rolled back. The same is true, if the procedure
starts a transaction, and then is aborted because of a reference to
a non-existing table.
On http://www.sommarskog.se/sqlutil/aba_lockinfo.html I have a
utility that gives yuu a lot of information about locks in the server,
including a list of which are the locked objects. This might be helpful
for you to understand where you are leaking transactions. (Although it
might be messy to find out. Because once a process has missed a
COMMIT or ROLLBACK, it will accumulate locks from all over the place.)
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
Friday, February 10, 2012
Clearing Transaction Log automatically...
I know this question has been asked before but I've found no answers that
seem to work.
I want to automatically clear my database transaction log to 10mb or so. My
current method is to detach the database. Rename the tlog file. Single file
attach the database. Then delete the tlog file.
I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
yet to get BACKUP LOG to work. Can someone offer any advise?
Thanks in advance for any help you can offer.What errors do you get when you try the backup log statement?
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Mike" <mschultz@.doitsmarter.com> wrote in message
news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> I know this question has been asked before but I've found no answers that
> seem to work.
> I want to automatically clear my database transaction log to 10mb or so.
My
> current method is to detach the database. Rename the tlog file. Single
file
> attach the database. Then delete the tlog file.
> I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
> yet to get BACKUP LOG to work. Can someone offer any advise?
> Thanks in advance for any help you can offer.
>
>|||1. To backup the log you must be in FUll recovery mode.
2. To backup the log you must have first backed up the entire database at
least once.
After backing up the log, then try shrinkfile..
"Mike" <mschultz@.doitsmarter.com> wrote in message
news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> I know this question has been asked before but I've found no answers that
> seem to work.
> I want to automatically clear my database transaction log to 10mb or so.
My
> current method is to detach the database. Rename the tlog file. Single
file
> attach the database. Then delete the tlog file.
> I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
> yet to get BACKUP LOG to work. Can someone offer any advise?
> Thanks in advance for any help you can offer.
>
>|||Thank you for the suggestions. Will give them a shot.
Mike
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:e1FNUGzuDHA.1512@.TK2MSFTNGP10.phx.gbl...
> 1. To backup the log you must be in FUll recovery mode.
> 2. To backup the log you must have first backed up the entire database at
> least once.
> After backing up the log, then try shrinkfile..
> "Mike" <mschultz@.doitsmarter.com> wrote in message
> news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> > I know this question has been asked before but I've found no answers
that
> > seem to work.
> >
> > I want to automatically clear my database transaction log to 10mb or
so.
> My
> > current method is to detach the database. Rename the tlog file. Single
> file
> > attach the database. Then delete the tlog file.
> >
> > I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I
have
> > yet to get BACKUP LOG to work. Can someone offer any advise?
> >
> > Thanks in advance for any help you can offer.
> >
> >
> >
>
seem to work.
I want to automatically clear my database transaction log to 10mb or so. My
current method is to detach the database. Rename the tlog file. Single file
attach the database. Then delete the tlog file.
I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
yet to get BACKUP LOG to work. Can someone offer any advise?
Thanks in advance for any help you can offer.What errors do you get when you try the backup log statement?
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Mike" <mschultz@.doitsmarter.com> wrote in message
news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> I know this question has been asked before but I've found no answers that
> seem to work.
> I want to automatically clear my database transaction log to 10mb or so.
My
> current method is to detach the database. Rename the tlog file. Single
file
> attach the database. Then delete the tlog file.
> I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
> yet to get BACKUP LOG to work. Can someone offer any advise?
> Thanks in advance for any help you can offer.
>
>|||1. To backup the log you must be in FUll recovery mode.
2. To backup the log you must have first backed up the entire database at
least once.
After backing up the log, then try shrinkfile..
"Mike" <mschultz@.doitsmarter.com> wrote in message
news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> I know this question has been asked before but I've found no answers that
> seem to work.
> I want to automatically clear my database transaction log to 10mb or so.
My
> current method is to detach the database. Rename the tlog file. Single
file
> attach the database. Then delete the tlog file.
> I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I have
> yet to get BACKUP LOG to work. Can someone offer any advise?
> Thanks in advance for any help you can offer.
>
>|||Thank you for the suggestions. Will give them a shot.
Mike
"Wayne Snyder" <wsnyder@.computeredservices.com> wrote in message
news:e1FNUGzuDHA.1512@.TK2MSFTNGP10.phx.gbl...
> 1. To backup the log you must be in FUll recovery mode.
> 2. To backup the log you must have first backed up the entire database at
> least once.
> After backing up the log, then try shrinkfile..
> "Mike" <mschultz@.doitsmarter.com> wrote in message
> news:O1ZPqJtuDHA.2360@.TK2MSFTNGP10.phx.gbl...
> > I know this question has been asked before but I've found no answers
that
> > seem to work.
> >
> > I want to automatically clear my database transaction log to 10mb or
so.
> My
> > current method is to detach the database. Rename the tlog file. Single
> file
> > attach the database. Then delete the tlog file.
> >
> > I've tried DBCC SHRINKFILE (MYDB, 10) but this doesn't work. And I
have
> > yet to get BACKUP LOG to work. Can someone offer any advise?
> >
> > Thanks in advance for any help you can offer.
> >
> >
> >
>
Clearing LOG Files?
I know that the Transaction LOG files are cleared when the DB is backed-up, but is there any way to clear the log files when they become too big, without backing-up the DB?
Thanx..
The log files are not emptied when you do BACKUP DATABASE. They are emptied when you do BACKUP LOG.
If you don't do log backups, just set the database to simple recovery mode...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is backed-up, but is there any way to clear
the log files when they become too big, without backing-up the DB?
> Thanx..
|||What recovery mode is your database is in?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big,
without backing-up the DB?
Thanx..
|||Rival,
Actually, the Transaction Logs are cleared when the Transaction Logs are
backed up, not when the Database is backed up. So, if only the DB is being
backed up the log will grow and grow and grow. So, you first step is to
make sure that the transaction log is being backed up.
If you need to abandon part of the log, you options are:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
or, switch to the SIMPLE recovery model:
ALTER DATABASE dbname SET RECOVERY SIMPLE
If the physical LOG file is too large, you would need to use DBCC SHRINKFILE
to physically shrink it after truncation.
Russell Fields
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is
backed-up, but is there any way to clear the log files when they become too
big, without backing-up the DB?
> Thanx..
|||Thanx a lot.
Misconception cleared up... :-) I'll give it a try.
Thanx..
The log files are not emptied when you do BACKUP DATABASE. They are emptied when you do BACKUP LOG.
If you don't do log backups, just set the database to simple recovery mode...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is backed-up, but is there any way to clear
the log files when they become too big, without backing-up the DB?
> Thanx..
|||What recovery mode is your database is in?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big,
without backing-up the DB?
Thanx..
|||Rival,
Actually, the Transaction Logs are cleared when the Transaction Logs are
backed up, not when the Database is backed up. So, if only the DB is being
backed up the log will grow and grow and grow. So, you first step is to
make sure that the transaction log is being backed up.
If you need to abandon part of the log, you options are:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
or, switch to the SIMPLE recovery model:
ALTER DATABASE dbname SET RECOVERY SIMPLE
If the physical LOG file is too large, you would need to use DBCC SHRINKFILE
to physically shrink it after truncation.
Russell Fields
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is
backed-up, but is there any way to clear the log files when they become too
big, without backing-up the DB?
> Thanx..
|||Thanx a lot.
Misconception cleared up... :-) I'll give it a try.
Clearing LOG Files?
I know that the Transaction LOG files are cleared when the DB is backed-up, but is there any way to clear the log files when they become too big, without backing-up the DB?
Thanx..The log files are not emptied when you do BACKUP DATABASE. They are emptied when you do BACKUP LOG.
If you don't do log backups, just set the database to simple recovery mode...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is backed-up, but is there any way to clear
the log files when they become too big, without backing-up the DB?
> Thanx..|||What recovery mode is your database is in?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big,
without backing-up the DB?
Thanx..|||Rival,
Actually, the Transaction Logs are cleared when the Transaction Logs are
backed up, not when the Database is backed up. So, if only the DB is being
backed up the log will grow and grow and grow. So, you first step is to
make sure that the transaction log is being backed up.
If you need to abandon part of the log, you options are:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
or, switch to the SIMPLE recovery model:
ALTER DATABASE dbname SET RECOVERY SIMPLE
If the physical LOG file is too large, you would need to use DBCC SHRINKFILE
to physically shrink it after truncation.
Russell Fields
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is
backed-up, but is there any way to clear the log files when they become too
big, without backing-up the DB?
> Thanx..
Thanx..The log files are not emptied when you do BACKUP DATABASE. They are emptied when you do BACKUP LOG.
If you don't do log backups, just set the database to simple recovery mode...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is backed-up, but is there any way to clear
the log files when they become too big, without backing-up the DB?
> Thanx..|||What recovery mode is your database is in?
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big,
without backing-up the DB?
Thanx..|||Rival,
Actually, the Transaction Logs are cleared when the Transaction Logs are
backed up, not when the Database is backed up. So, if only the DB is being
backed up the log will grow and grow and grow. So, you first step is to
make sure that the transaction log is being backed up.
If you need to abandon part of the log, you options are:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
or, switch to the SIMPLE recovery model:
ALTER DATABASE dbname SET RECOVERY SIMPLE
If the physical LOG file is too large, you would need to use DBCC SHRINKFILE
to physically shrink it after truncation.
Russell Fields
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is
backed-up, but is there any way to clear the log files when they become too
big, without backing-up the DB?
> Thanx..
Clearing LOG Files?
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big, withou
t backing-up the DB?
Thanx..The log files are not emptied when you do BACKUP DATABASE. They are emptied
when you do BACKUP LOG.
If you don't do log backups, just set the database to simple recovery mode..
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is backed-up, but is
there any way to clear
the log files when they become too big, without backing-up the DB?
> Thanx..|||What recovery mode is your database is in?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big,
without backing-up the DB?
Thanx..|||Rival,
Actually, the Transaction Logs are cleared when the Transaction Logs are
backed up, not when the Database is backed up. So, if only the DB is being
backed up the log will grow and grow and grow. So, you first step is to
make sure that the transaction log is being backed up.
If you need to abandon part of the log, you options are:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
or, switch to the SIMPLE recovery model:
ALTER DATABASE dbname SET RECOVERY SIMPLE
If the physical LOG file is too large, you would need to use DBCC SHRINKFILE
to physically shrink it after truncation.
Russell Fields
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is
backed-up, but is there any way to clear the log files when they become too
big, without backing-up the DB?
> Thanx..|||Thanx a lot.
Misconception cleared up... :-) I'll give it a try.
but is there any way to clear the log files when they become too big, withou
t backing-up the DB?
Thanx..The log files are not emptied when you do BACKUP DATABASE. They are emptied
when you do BACKUP LOG.
If you don't do log backups, just set the database to simple recovery mode..
.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is backed-up, but is
there any way to clear
the log files when they become too big, without backing-up the DB?
> Thanx..|||What recovery mode is your database is in?
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
I know that the Transaction LOG files are cleared when the DB is backed-up,
but is there any way to clear the log files when they become too big,
without backing-up the DB?
Thanx..|||Rival,
Actually, the Transaction Logs are cleared when the Transaction Logs are
backed up, not when the Database is backed up. So, if only the DB is being
backed up the log will grow and grow and grow. So, you first step is to
make sure that the transaction log is being backed up.
If you need to abandon part of the log, you options are:
BACKUP LOG { database_name | @.database_name_var }
{
[ WITH
{ NO_LOG | TRUNCATE_ONLY } ]
}
or, switch to the SIMPLE recovery model:
ALTER DATABASE dbname SET RECOVERY SIMPLE
If the physical LOG file is too large, you would need to use DBCC SHRINKFILE
to physically shrink it after truncation.
Russell Fields
"Rival" <anonymous@.discussions.microsoft.com> wrote in message
news:5BBFA001-3CF0-46E7-AE86-3185C5B9CCA8@.microsoft.com...
> I know that the Transaction LOG files are cleared when the DB is
backed-up, but is there any way to clear the log files when they become too
big, without backing-up the DB?
> Thanx..|||Thanx a lot.
Misconception cleared up... :-) I'll give it a try.
clearing log
As a relative newcomer to MSSQL, I've been playing around with a database,
adding and removing tables and tons of data. Now I'm ready to get down to
business.
I notice that the log (LDF file) is now three times the size of the database
itself. I'm pretty sure there's nothing in there that is of any use. Is
there a way to clear it? Is that desirable? Am I better off starting over
with a new database? This one does have some, not a lot, data in it that I'd
like to keep.Try in Query Analyser
BACKUP LOG WITH TRUNCATE_ONLY
Then
DBCC SHRINKFILE( look in BOL for more detail)
If you don't want to do this repeatedly, you can modify the Recovery
Model of the database !
Go to your Database Property, on the last tab, you'll se the recovery
model is at Full or Bulked-Logged, change it to Simple ! Your log will
stop accumulating !
You can also change the recovery model of Model database so the next
database you create will use simple recovery !
For more information on Recovery Model, search BOL
Pollus Brodeur|||If you don't do regular transaction log backups, set the database to simple
recovery mode. Shrinking
considerations: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Pedersen" <no-reply@.swen.com> wrote in message news:eoMfbUaXFHA.616@.TK2MSFTNGP12.phx.
gbl...
> As a relative newcomer to MSSQL, I've been playing around with a database,
adding and removing
> tables and tons of data. Now I'm ready to get down to business.
> I notice that the log (LDF file) is now three times the size of the databa
se itself. I'm pretty
> sure there's nothing in there that is of any use. Is there a way to clear
it? Is that desirable?
> Am I better off starting over with a new database? This one does have some
, not a lot, data in it
> that I'd like to keep.
>
>
>
>|||Thanks to all.
"Paul Pedersen" <no-reply@.swen.com> wrote in message
news:eoMfbUaXFHA.616@.TK2MSFTNGP12.phx.gbl...
> As a relative newcomer to MSSQL, I've been playing around with a database,
> adding and removing tables and tons of data. Now I'm ready to get down to
> business.
> I notice that the log (LDF file) is now three times the size of the
> database itself. I'm pretty sure there's nothing in there that is of any
> use. Is there a way to clear it? Is that desirable? Am I better off
> starting over with a new database? This one does have some, not a lot,
> data in it that I'd like to keep.
>
>
>
>
adding and removing tables and tons of data. Now I'm ready to get down to
business.
I notice that the log (LDF file) is now three times the size of the database
itself. I'm pretty sure there's nothing in there that is of any use. Is
there a way to clear it? Is that desirable? Am I better off starting over
with a new database? This one does have some, not a lot, data in it that I'd
like to keep.Try in Query Analyser
BACKUP LOG WITH TRUNCATE_ONLY
Then
DBCC SHRINKFILE( look in BOL for more detail)
If you don't want to do this repeatedly, you can modify the Recovery
Model of the database !
Go to your Database Property, on the last tab, you'll se the recovery
model is at Full or Bulked-Logged, change it to Simple ! Your log will
stop accumulating !
You can also change the recovery model of Model database so the next
database you create will use simple recovery !
For more information on Recovery Model, search BOL
Pollus Brodeur|||If you don't do regular transaction log backups, set the database to simple
recovery mode. Shrinking
considerations: http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Paul Pedersen" <no-reply@.swen.com> wrote in message news:eoMfbUaXFHA.616@.TK2MSFTNGP12.phx.
gbl...
> As a relative newcomer to MSSQL, I've been playing around with a database,
adding and removing
> tables and tons of data. Now I'm ready to get down to business.
> I notice that the log (LDF file) is now three times the size of the databa
se itself. I'm pretty
> sure there's nothing in there that is of any use. Is there a way to clear
it? Is that desirable?
> Am I better off starting over with a new database? This one does have some
, not a lot, data in it
> that I'd like to keep.
>
>
>
>|||Thanks to all.
"Paul Pedersen" <no-reply@.swen.com> wrote in message
news:eoMfbUaXFHA.616@.TK2MSFTNGP12.phx.gbl...
> As a relative newcomer to MSSQL, I've been playing around with a database,
> adding and removing tables and tons of data. Now I'm ready to get down to
> business.
> I notice that the log (LDF file) is now three times the size of the
> database itself. I'm pretty sure there's nothing in there that is of any
> use. Is there a way to clear it? Is that desirable? Am I better off
> starting over with a new database? This one does have some, not a lot,
> data in it that I'd like to keep.
>
>
>
>
Clear/Purge Log files
The MDF file is 800 MB but the LDF file is 5 GB. I run the "shrink database"
but this does not seems to reduce the mdf or ldf filesize.
What I did is detach the database, delete the ldf file, re-attach the
database to create a new ldf file. If I do not do so, the application cannot
work (hang!) because the ldf file is too huge and it takes ages to commit a
transaction. Is there a "better" way to control the ldf file like
auto-purging ? Should I restrict the log file size to a specific filesize
like 500MB ? Does this mean it will auto-purge each time it reach 500MB for
the ldf file ?
Thanks
The way you manage your log file is driven by your database recovery plan.
If your recovery plan is to restore from your last full backup and not apply
transaction log backups, then change your database recovery model to SIMPLE.
This will keep your log size reasonable by removing committed transactions
from the log. The log will still need to be large enough to accommodate
your largest single transaction. If you want to reduce potential data loss,
you should use the BULK_LOGGED or FULL recovery model and backup your log
periodically.
The proper way to shrink files is with DBCC SHRINKFILE. See the Books
Online for details. You should not need to do this as part of routine
maintenance.
Hope this helps.
Dan Guzman
SQL Server MVP
"Carlos" <wt_know@.hotmail.com> wrote in message
news:OueiitTPEHA.620@.TK2MSFTNGP10.phx.gbl...
> The MDF file is 800 MB but the LDF file is 5 GB. I run the "shrink
database"
> but this does not seems to reduce the mdf or ldf filesize.
> What I did is detach the database, delete the ldf file, re-attach the
> database to create a new ldf file. If I do not do so, the application
cannot
> work (hang!) because the ldf file is too huge and it takes ages to commit
a
> transaction. Is there a "better" way to control the ldf file like
> auto-purging ? Should I restrict the log file size to a specific filesize
> like 500MB ? Does this mean it will auto-purge each time it reach 500MB
for
> the ldf file ?
> Thanks
>
>
|||Hi,
Instead of detaching , delete the LDF file, Attach the database ytou should
have tried the below steps:-
Alter database <dbname> set single_user with rollback immediate
go
backup log <dbname> to disk='d:\backup\dbname.trn1'
go
dbcc shrinkfile('logical_log_name',truncateonly)
go
Alter database <dbname> set multi_user
After executing the above you can execute the below command check the log
file size and usage,
dbcc sqlperf(logspace)
Like Dan suggested go for SIMPLE recovery model if your data is not critical
or you not require a transaction log based recovery (POINT_IN_TIME).
Thanks
Hari
MCDBA
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:uTGdG0TPEHA.2256@.TK2MSFTNGP10.phx.gbl...
> The way you manage your log file is driven by your database recovery plan.
> If your recovery plan is to restore from your last full backup and not
apply
> transaction log backups, then change your database recovery model to
SIMPLE.
> This will keep your log size reasonable by removing committed transactions
> from the log. The log will still need to be large enough to accommodate
> your largest single transaction. If you want to reduce potential data
loss,[vbcol=seagreen]
> you should use the BULK_LOGGED or FULL recovery model and backup your log
> periodically.
> The proper way to shrink files is with DBCC SHRINKFILE. See the Books
> Online for details. You should not need to do this as part of routine
> maintenance.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Carlos" <wt_know@.hotmail.com> wrote in message
> news:OueiitTPEHA.620@.TK2MSFTNGP10.phx.gbl...
> database"
> cannot
commit[vbcol=seagreen]
> a
filesize
> for
>
|||Thanks for the advices ! :-)
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MWo0lUPEHA.3328@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Instead of detaching , delete the LDF file, Attach the database ytou
should
> have tried the below steps:-
> Alter database <dbname> set single_user with rollback immediate
> go
> backup log <dbname> to disk='d:\backup\dbname.trn1'
> go
> dbcc shrinkfile('logical_log_name',truncateonly)
> go
> Alter database <dbname> set multi_user
> After executing the above you can execute the below command check the log
> file size and usage,
> dbcc sqlperf(logspace)
> Like Dan suggested go for SIMPLE recovery model if your data is not
critical[vbcol=seagreen]
> or you not require a transaction log based recovery (POINT_IN_TIME).
> Thanks
> Hari
> MCDBA
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:uTGdG0TPEHA.2256@.TK2MSFTNGP10.phx.gbl...
plan.[vbcol=seagreen]
> apply
> SIMPLE.
transactions[vbcol=seagreen]
> loss,
log[vbcol=seagreen]
> commit
> filesize
500MB
>
but this does not seems to reduce the mdf or ldf filesize.
What I did is detach the database, delete the ldf file, re-attach the
database to create a new ldf file. If I do not do so, the application cannot
work (hang!) because the ldf file is too huge and it takes ages to commit a
transaction. Is there a "better" way to control the ldf file like
auto-purging ? Should I restrict the log file size to a specific filesize
like 500MB ? Does this mean it will auto-purge each time it reach 500MB for
the ldf file ?
Thanks
The way you manage your log file is driven by your database recovery plan.
If your recovery plan is to restore from your last full backup and not apply
transaction log backups, then change your database recovery model to SIMPLE.
This will keep your log size reasonable by removing committed transactions
from the log. The log will still need to be large enough to accommodate
your largest single transaction. If you want to reduce potential data loss,
you should use the BULK_LOGGED or FULL recovery model and backup your log
periodically.
The proper way to shrink files is with DBCC SHRINKFILE. See the Books
Online for details. You should not need to do this as part of routine
maintenance.
Hope this helps.
Dan Guzman
SQL Server MVP
"Carlos" <wt_know@.hotmail.com> wrote in message
news:OueiitTPEHA.620@.TK2MSFTNGP10.phx.gbl...
> The MDF file is 800 MB but the LDF file is 5 GB. I run the "shrink
database"
> but this does not seems to reduce the mdf or ldf filesize.
> What I did is detach the database, delete the ldf file, re-attach the
> database to create a new ldf file. If I do not do so, the application
cannot
> work (hang!) because the ldf file is too huge and it takes ages to commit
a
> transaction. Is there a "better" way to control the ldf file like
> auto-purging ? Should I restrict the log file size to a specific filesize
> like 500MB ? Does this mean it will auto-purge each time it reach 500MB
for
> the ldf file ?
> Thanks
>
>
|||Hi,
Instead of detaching , delete the LDF file, Attach the database ytou should
have tried the below steps:-
Alter database <dbname> set single_user with rollback immediate
go
backup log <dbname> to disk='d:\backup\dbname.trn1'
go
dbcc shrinkfile('logical_log_name',truncateonly)
go
Alter database <dbname> set multi_user
After executing the above you can execute the below command check the log
file size and usage,
dbcc sqlperf(logspace)
Like Dan suggested go for SIMPLE recovery model if your data is not critical
or you not require a transaction log based recovery (POINT_IN_TIME).
Thanks
Hari
MCDBA
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:uTGdG0TPEHA.2256@.TK2MSFTNGP10.phx.gbl...
> The way you manage your log file is driven by your database recovery plan.
> If your recovery plan is to restore from your last full backup and not
apply
> transaction log backups, then change your database recovery model to
SIMPLE.
> This will keep your log size reasonable by removing committed transactions
> from the log. The log will still need to be large enough to accommodate
> your largest single transaction. If you want to reduce potential data
loss,[vbcol=seagreen]
> you should use the BULK_LOGGED or FULL recovery model and backup your log
> periodically.
> The proper way to shrink files is with DBCC SHRINKFILE. See the Books
> Online for details. You should not need to do this as part of routine
> maintenance.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Carlos" <wt_know@.hotmail.com> wrote in message
> news:OueiitTPEHA.620@.TK2MSFTNGP10.phx.gbl...
> database"
> cannot
commit[vbcol=seagreen]
> a
filesize
> for
>
|||Thanks for the advices ! :-)
"Hari" <hari_prasad_k@.hotmail.com> wrote in message
news:%23MWo0lUPEHA.3328@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Instead of detaching , delete the LDF file, Attach the database ytou
should
> have tried the below steps:-
> Alter database <dbname> set single_user with rollback immediate
> go
> backup log <dbname> to disk='d:\backup\dbname.trn1'
> go
> dbcc shrinkfile('logical_log_name',truncateonly)
> go
> Alter database <dbname> set multi_user
> After executing the above you can execute the below command check the log
> file size and usage,
> dbcc sqlperf(logspace)
> Like Dan suggested go for SIMPLE recovery model if your data is not
critical[vbcol=seagreen]
> or you not require a transaction log based recovery (POINT_IN_TIME).
> Thanks
> Hari
> MCDBA
>
> "Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
> news:uTGdG0TPEHA.2256@.TK2MSFTNGP10.phx.gbl...
plan.[vbcol=seagreen]
> apply
> SIMPLE.
transactions[vbcol=seagreen]
> loss,
log[vbcol=seagreen]
> commit
> filesize
500MB
>
Subscribe to:
Posts (Atom)