I used a temporary table in a stored procedure.Whenever this stored procedure is executed with the desired output it is giving the warning message-
Warning: The table '#TEMPTBLPERSON' has been created but its maximum row size (10930) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Now my question is how can I avoid of displaying this warning message
in the stored procedure without altering the temporary table ?Originally posted by subhasishray
I used a temporary table in a stored procedure.Whenever this stored procedure is executed with the desired output it is giving the warning message-
Warning: The table '#TEMPTBLPERSON' has been created but its maximum row size (10930) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Now my question is how can I avoid of displaying this warning message
in the stored procedure without altering the temporary table ?
The best way is to reduce the data size of the table to less than 8060 bytes.
other way .. i believe might be to set the option
set ansi_warnings off|||I wrote clearly I don't want to reduce the length of the table.
set ansi_warnings_off|on is not giving desired output.
Subhasish|||Originally posted by subhasishray
I wrote clearly I don't want to reduce the length of the table.
set ansi_warnings_off|on is not giving desired output.
Subhasish
Clearly ... you are not paying heed to the warning message .. An insert into your table will fail in case the data is more than 8060 bytes . You should take that case into consideration.
Am searching for the other answer .. will get back as soon as i find it|||There is no "other" answer, you've said it all. the only other thing to do would be to split the table into 2 with 1-to-1 relationship.|||I was searching for a server property where i could control the severity level of warnings and errors as is availible in osql with the -m flag.|||Originally posted by subhasishray
I wrote clearly I don't want to reduce the length of the table.
set ansi_warnings_off|on is not giving desired output.
Subhasish
Whether you know it or not...that comes across with some attitude..
If you can't be flexible...then I don't know who will...
good luck...
Showing posts with label procedure. Show all posts
Showing posts with label procedure. Show all posts
Friday, March 30, 2012
Monday, March 26, 2012
Restoring the database using stored procedure
hey guyz...
i used this stored procedure code my system.. but it crashes saying "exclusive access could not be obtained becuase the database is in use"
i have included the stored procedure below. is the stored procedure correct?
if it is.. how can i sovle this problem?
CREATE Procedure spRestoreDatabase
@.Path VARCHAR(100)
AS
Restore Database Test From Disk = @.Path
GOA database restore can only be done when you've got exclusive use of the database. No other users can be using the database besides the one doing the restore.
The procedure can't be in the database, because then the spid trying to restore the datbase would need to be executing code in the database which would prevent the restore.
An SQL Agent job would be a better choice than a stored procedure. You may need to think about using ALTER DATABASE to force the other users out of the database, but think that through carefully before you try to use it because it can cause other problems.
-PatP|||erm... so what can i do now?|||Put your stored procedure in a different database and run it from there.
Gotta ask why you need a stored proc to restore your database in the first place. Surely this isn't going to be an automated task?|||erm... so what can i do now?As blindman pointed out, your first step ought to be to rethink what you are doing. Try to determine if there is some better way than an automated restore.
If you really, truly need to automate the restore, I'd do it as a SQL Agent Job myself. You can actually get pretty tricky with jobs, and do nearly anything you can do with a stored procedure, plus a whole lot more.
Before you get too busy coding, think hard about what you are doing, why you are doing it, and whether there are any alternatives. You are headed into the area that cartographers of olde used to label "Here be dragons"
-PatPsql
i used this stored procedure code my system.. but it crashes saying "exclusive access could not be obtained becuase the database is in use"
i have included the stored procedure below. is the stored procedure correct?
if it is.. how can i sovle this problem?
CREATE Procedure spRestoreDatabase
@.Path VARCHAR(100)
AS
Restore Database Test From Disk = @.Path
GOA database restore can only be done when you've got exclusive use of the database. No other users can be using the database besides the one doing the restore.
The procedure can't be in the database, because then the spid trying to restore the datbase would need to be executing code in the database which would prevent the restore.
An SQL Agent job would be a better choice than a stored procedure. You may need to think about using ALTER DATABASE to force the other users out of the database, but think that through carefully before you try to use it because it can cause other problems.
-PatP|||erm... so what can i do now?|||Put your stored procedure in a different database and run it from there.
Gotta ask why you need a stored proc to restore your database in the first place. Surely this isn't going to be an automated task?|||erm... so what can i do now?As blindman pointed out, your first step ought to be to rethink what you are doing. Try to determine if there is some better way than an automated restore.
If you really, truly need to automate the restore, I'd do it as a SQL Agent Job myself. You can actually get pretty tricky with jobs, and do nearly anything you can do with a stored procedure, plus a whole lot more.
Before you get too busy coding, think hard about what you are doing, why you are doing it, and whether there are any alternatives. You are headed into the area that cartographers of olde used to label "Here be dragons"
-PatPsql
Restoring stored procedure HELP!
Someone accidently deleted some of a stored procedure. Is it possible to
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?
Hi
Restore the DB as a different DB on the server and copy it over.
Regards
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/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?
|||You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
David Portas
SQL Server MVP
|||restore primary filegroup and copy sp
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and copy
> that one store procedure?
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?
Hi
Restore the DB as a different DB on the server and copy it over.
Regards
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/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?
|||You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
David Portas
SQL Server MVP
|||restore primary filegroup and copy sp
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and copy
> that one store procedure?
Restoring stored procedure HELP!
Someone accidently deleted some of a stored procedure. Is it possible to
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?Hi
Restore the DB as a different DB on the server and copy it over.
Regards
--
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/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?|||You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
David Portas
SQL Server MVP
--|||restore primary filegroup and copy sp
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and cop
y
> that one store procedure?sql
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?Hi
Restore the DB as a different DB on the server and copy it over.
Regards
--
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/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?|||You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
David Portas
SQL Server MVP
--|||restore primary filegroup and copy sp
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and cop
y
> that one store procedure?sql
Restoring stored procedure HELP!
Someone accidently deleted some of a stored procedure. Is it possible to
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
--
David Portas
SQL Server MVP
--|||Hi
Restore the DB as a different DB on the server and copy it over.
Regards
--
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/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?|||restore primary filegroup and copy sp
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and copy
> that one store procedure?
restore just that one whole procedure, or do we have to restore DB and copy
that one store procedure?You can't selectively restore objects. Restore the database elsewhere and
then copy the proc.
It's definitely good practice to keep a separate copy of your SQL source
code, just as you would for any other code in C# or VB. Use a source control
system such as Microsoft SourceSafe.
--
David Portas
SQL Server MVP
--|||Hi
Restore the DB as a different DB on the server and copy it over.
Regards
--
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/
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:4A8E8BD3-461B-4175-93B2-37F22B9F6B12@.microsoft.com...
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and
> copy
> that one store procedure?|||restore primary filegroup and copy sp
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"Mike" wrote:
> Someone accidently deleted some of a stored procedure. Is it possible to
> restore just that one whole procedure, or do we have to restore DB and copy
> that one store procedure?
Wednesday, March 21, 2012
Restoring one clusternode.
Hello,
I one clusternode fails. What is the procedure to reinstall the SQL software
INCLUDING SQL servicepacks? Preferrably without disturbing the remaining
node. Documents anyone ?
Also, SQL-logs, where could or should they reside ? On the same shared disk
as the db:s or on another one? Or maybe on a local disk ?
Regards
Johnny Lundgren
These are my notes with links at the end.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:C8CEA952-209A-41BF-8C85-F4473964CE62@.microsoft.com...
> Hello,
> I one clusternode fails. What is the procedure to reinstall the SQL
> software
> INCLUDING SQL servicepacks? Preferrably without disturbing the remaining
> node. Documents anyone ?
> Also, SQL-logs, where could or should they reside ? On the same shared
> disk
> as the db:s or on another one? Or maybe on a local disk ?
> Regards
> Johnny Lundgren
begin 666 Cluster.doc
MT,\1X*&Q&N$`````````````````````/@.`#`/[_"0`&```````````````!
M````. ``````````$ ``.@.````$```#^____`````#<```#_____________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_______________________LI<$`?V )! ``^!*_````````$ ``````!@.``
M+!(```X`8FIB:N:'YH<````````````````````````)!!8`+ B ``(3M``"$
M[0``+ H```````````````````````````````````````#__P\````` ````
M``#__P\```````````#__P\``````````````````````*0`` ````"0$````
M````) 0``"0$````````) 0````````D! ```````"0$````````) 0``!0`
M`````````````#@.$````````H T```````"@.#0```````* -````````H T`
M`!0```"T#0``' ```#@.$````````L18``.X```#<#0``< ```$P.````````
M3 X```````!,#@.```````$P.````````)P\``#X```!E#P``% ```'D/```,
M````,!8```(````R%@.```````#(6````````,A8````````R% @.```````#(6
M````````,A8``"0```"?%P``: (```<:``!.````5A8``!4`````````````
M````````````) 0```````"%#P`````````````````````````````G#P``
M`````"</````````A0\```````"%#P```````%86`````````````````` `D
M! ```````"0$````````3 X``````````````````$P.``#;````:Q8``!8`
M``!)$ ```````$D0````````21 ```````"%#P``(@.```"0$````````3 X`
M```````D! ```````$P.````````,!8``````````````````$D0````````
M````````````````````````````````````````````````` ```````````
M````A0\````````P%@.``````````````````21 ```````!)$ ``'@.```,H2
M```8````) 0````````D! ``````````````````````````````````````
M````````````````````````````````````````````%A,`` `````!,#@.``
M`````- -```,````X%.NFH#;Q0$``````````* -````````IP\``&H```#B
M$@.``" ``````````````,!8```````"!%@.``, ```+$6````````ZA(``"P`
M``!5&@.```````!$0```B````51H``! ````6$P``````````````````````
M````````````````````````````````````````````````` ```````````
M```````````6$P``D@.$``%4:```````````````````D! ```````*@.4``"(
M`0``A0\```````"%#P```````$D0````````A0\```````"%# P``````````
M````````````````````````````````````````A0\`````` `"%#P``````
M`(4/````````5A8```````!6%@.```````````````````````````` ``````
M````````````````,Q ``!8`````````````````````````````````````
M`````````(4/````````A0\```````"%#P```````+$6````````A0\`````
M``"%#P```````(4/````````A0\``````````````````#@.$````````. 0`
M```````X! ``Y <``!P,``"$`0``. 0````````X! ```````#@.$````````
M' P````````X! ```````#@.$````````. 0````````D! ```````"0$````
M````) 0````````D! ```````"0$````````) 0```````#_____``````(`
M# $````````````````````````````````````````````````` ````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ````%=I;F1O
M=W,@.,C P,R!C;'5S=&5R(&EN<W1A;&QA=&EO;B]F86EL=7)E+V5V:6-T:6]N
M+V%D9"!397)V:6-E('!A8VL@.;F]T97,-#5-13"!397)V:6-E(%!A8VMS#0U"
M969O<F4@.87!P;'EI;F<@.86YY('-E<G9I8V4@.<&%C:W,@.<')E<&%R92!A(&-O
M;G1I;F=E;F-Y('!L86X@.:6X@.8V%S92!O9B!C871A<W1R;W!H:6,@.9F%I;'5R
M92X-#4UA:V4@.<W5R92!T:&4@.;7-D8BP@.;6%S=&5R(&%N9"!M;V1E;"!D871A
M8F%S97,@.87)E(&)A8VME9"!U<"!T;R!A('-T;W)A9V4@.;65D:6$@.;F]T(&1E
M<&5N9&%N="!O;B!T:&4@.8VQU<W1E<B!B96EN9R!U<&=R861E9 "X@.268@.4U T
M(&EN<W1A;&QA=&EO;B!F86EL<R!T:&5N('1H97-E(&1A=&%B87-E<R!W:6QL
M(&AA=F4@.=&\@.8F4@.<F5S=&]R960@.8F5C875S92!T:&5Y(&%R92!A;65N9&5D
M(&)Y(%-0-"X-#4UA:V4@.<W5R92!Y;W4@.:&%V92!C=7)R96YT(&)A8VMU<',@.
M;V8@.87!P;&EC871I;VX@.9&%T86)A<V5S(&%G86EN(&YO="!O; B!S=&]R86=E
M(&UE9&EA(&1E<&5N9&%N="!O;B!T:&4@.8VQU<W1E<B!B96EN9 R!U<&=R861E
M9"X-#4UA:V4@.<W5R92!T:&%T(%-0,R!I<R!A<'!L:65D(&)E9F]R92!A<'!L
M>6EN9R!34#0N#0U.;V1E($9A:6QU<F4-#55S:6YG(&-L=7-T97(@.861M:6YI
M<W1R871O<B!S=&]P('1H92!C;'5S=&5R('-E<G9I8V4@.;VX@.=&AE(&9A:6QE
M9"!N;V1E(&%N9"!E=FEC="!T:&4@.9F%I;&5D(&YO9&4-#5)E8G5I;&0@.=&AE
M('-E<G9E<B!W:71H('1H92!H;W-T($]3(&%N9"!S86UE('-E<G9I8V4@.<&%C
M:R!A<R!O=&AE<B!N;V1E<R!I;B!T:&4@.8VQU<W1E<BX-#55S:6YG(&-L=7-T
M97(@.861M:6YI<W1R871O<B!A9&0@.=&AE(&YE=R!N;V1E('1O( '1H92!C;'5S
M=&5R+@.T-57-I;F<@.=&AE(%-13"!I;G-T86QL871I;VX@.0T0O9&ES:R!C;W!Y
M(')U;B!T:&4@.4U%,(&EN<W1A;&QA=&EO;BX@.#0U/;B!T:&4@.0V]M<'5T97(@.
M3F%M92!P86=E+"!T>7!E('1H92!V:7)T=6%L('-E<G9E<B!N86UE+"!C;&EC
M:R!6:7)T=6%L(%-E<G9E<BP@.86YD('1H96X@.8VQI8VL@.3F5X="X-#4QE879I
M;F<@.061V86YC960@.3W!T:6]N<R!S96QE8W1E9"P@.8VQI8VL@.3F5X="X-#4QE
M879I;F<@.36%I;G1A:6X@.82!6:7)T=6%L(%-E<G9E<B!F;W(@.1F%I;&]V97(@.
M0VQU<W1E<FEN9R!S96QE8W1E9"P@.8VQI8VL@.3F5X="X-#4]N('1H92!6:7)T
M=6%L(%-E<G9E<B!);F9O<FUA=&EO;B!P86=E+"!C;&EC:R!.97AT+@.T-3VX@.
M=&AE($-L=7-T97(@.36%N86=E;65N="!P86=E+"!C;&EC:R!T:&4@.;F5W(&YO
M9&4L(&-L:6-K($%D9"P@.86YD('1H96X@.8VQI8VL@.3F5X="X-#45N=&5R('1H
M92!R96QE=F%N="!D971A:6QS+@.U!<'!L>2!344P@.4U S('!H>7-I8V%L;'D@.
M;VX@.=&AE(')E8G5I;'0@.;F]D92X-07!P;'D@.4U T('1O('1H92!O=&AE<B H
M;F]N+69A:6QE9"D@.;F]D92 H979E;B!I9B!I="!H87,@.86QR96%D>2!B965N
M(&%P<&QI960I+B!4:&ES('=I;&P@.87!P;'D@.4U T('1O(&)O=&@.@.;F]D97,@.
M8G)I;F=I;F<@.=&AE;2!I;B!L:6YE+B!9;W4@.;6%Y(&YE960@.= &\@.9&5L971E
M($Y%141?4U!?2T59(&9R;VT@.=&AE(')E9VES=')Y(&]F(&)O=&@.@.8V]M<'5T
M97)S(&)E9F]R92!A<'!L>6EN9R!34#0N#0T-#51H92!F;VQL;W=I;F<@.;&EN
M:W,@.<')O=FED92!A;&P@.=&AE(&EN9F]R;6%T:6]N('1H870@.:7,@.<F5Q=6ER
M960N#0T3($A94$523$E.2R B:'1T<#HO+W=W=RYM:6-R;W-O9G0N8V]M+V1O
M=VYL;V%D<R]D971A:6QS+F%S<'@._1F%M:6QY240].39F-S9E9#<M.38S-"TT
M,S P+3DQ-3DM.#DV,SAF-&(T968W)F1I<W!L87EL86YG/65N(B !%$1O=VYL
M;V%D(&1E=&%I;',Z($=U:61E('1O($-R96%T:6YG(&%N9"!#;VYF:6=U<FEN
M9R!A(%-E<G9E<B!#;'5S=&5R(%5N9&5R(%=I;F1O=W,@.4V5R=F5R(#(P, #,5
M#0T3($A94$523$E.2R B:'1T<#HO+W=W=RYS<6PM<V5R=F5R+7!E<F9O<FUA
M;F-E+F-O;2]S<6QS97)V97(R,# P7V-L=7-T97)I;F=?:6YS=&%L;%]M86EN
M+F%S<"(@.`11(;W<@.=&\@.26YS=&%L;"!344P@.4V5R=F5R(#(P, # @.0VQU<W1E
M<FEN9Q4-#1,@.2%E015),24Y+(")H='1P.B\O<W5P<&]R="YM:6-R;W-O9G0N
M8V]M+S]K8FED/3,P,38P,"(@.`11(;W<@.=&\@.8V]N9FEG=7)E($UI8W)O<V]F
M="!$:7-T<FEB=71E9"!4<F%N<V%C=&EO;B!#;V]R9&EN871O<B!O;B!A(%=I
M;F1O=W,@.4V5R=F5R(#(P,#,@.8VQU<W1E<A4-#1,@.2%E015),24Y+(")H='1P
M.B\O=W=W+FUI8W)O<V]F="YC;VTO=&5C:&YE="]P<F]D=&5C:&YO;"]S<6PO
M,C P,"]M86EN=&%I;B]F86EL8VQU<RYM<W!X(B !%$UI8W)O<V]F="!344P@.
M4V5R=F5R(#(P,# @.1F%I;&]V97(@.0VQU<W1E<FEN9Q4-#1,@.2%E015),24Y+
M(")H='1P.B\O=W=W+FUI8W)O<V]F="YC;VTO=&5C:&YE="]P<F]D=&5C:&YO
M;"]S<6PO,C P,"]D97!L;WDO:&%S;V<P,2YM<W!X(B !%%-13"!397)V97(@.
M,C P,"!(:6=H($%V86EL86)I;&ET>2!397)I97,Z($EM<&QE;65N= &EN9R!&
M86EL;W9E<B!#;'5S=&5R:6YG%0T-$R!(65!%4DQ)3DL@.(FAT=' Z+R]W=W<N
M;6-S92YM<R]M97-S86=E,3<U.38V-"YH=&UL(B !%$%D9&EN9R!N97<@.;F]D
M92!T;R!344P@.4U T(&-L=7-T97(5#0T-#0T-#0T-#0T-#0``````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M```````````&``!)" ``2@.@.``$L(``!/" ``7 @.``%X(``!F" ``60H``&4*
M``!G"@.``CPH``+0*```""P``%0L``"0+``"D"P``I@.L``*T+` `"Z"P``Y0L`
M`/,+```$# ``" P``!,,```C# ``- P``#@.,``!## ``= P``(4,``")# ``
MDPP``*T,``"Z# ``O@.P``,@.,``#:# ``^PP``/X,```/#0``$PT``!4-```6
M#0``Z T``$0.``"+#@.``C X```8/```'#P``" \``&8/``!G#P``:0\``&H/
M``#'#P``R \``/?OZ^;WYM_K]^;KV^O7Z]?;T,;0QM#&T,;0QM#&T,;0QM#&
MT,;0QM#&T+K;MMNNVZ.NFJ[;KMN/```5`@.B!`VI+`0``!@.@.!%F@.R'(P`50@.!
M$!5H,AR,`!9H,AR,`#!*#P``%0((@.0-J``````8(`19H,AR,`%4(`0\#:@.``
M```6:#(<C !5" $&%FCJ#F@.``!86:#(<C !#2A$`3TH#`%%*`P!A2A$``!(5
M:#(<C `6:#(<C `U"(%<"($`#!5H,AR,`!9H,AR,```&%F@.2$3L```86:#(<
MC ``#!5HNP<^`!9HNP<^```)%FB[!SX`/BH!!A9HNP<^```/%6B[!SX`%FA#
M1YT`/BH!#Q5HNP<^`!9HNP<^`#XJ`0`X``8``$H(``!+" ``70@.``%X(``"\
M" ``O0@.``*,)``"D"0``) H``"4*``!8"@.``60H``&8*``!G"@.``R0H``,H*
M```C"P``) L``&$+``!B"P``I0L``*8+```*# ``"PP``#H,```[# ``BPP`
M`/T```````````````#]````````````````_0```````````````/T`````
M``````````#X````````````````^ ```````````````/@.`````````````
M``#X````````````````^ ```````````````/@.```````````````#X````
M````````````^ ```````````````/@.```````````````#X````````````
M````^ ```````````````/@.```````````````#X````````````````\P``
M`````````````/,```````````````#S````````````````ZP``````````
M`````.L```````````````#K````````````````ZP``````` ````````.L`
M``````````````#K````````````````ZP``````````````` ```````````
M!P``$F10`0$`9V0R'(P```0``&=D$A$[```$``!G9+L'/@.```0```!L`!@.``
M+!(``/T````````````````````````````````````````````````` ````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````````0$``$!`8L,``",# ``P P``,$,```5#0``%@.T``#(-``!@.#0``
M10X``$8.``!'#@.``2 X``(H.``"+#@.``: \``&D/``#T#P``]0\``) 0``"1
M$ ``'1$``!X1``#$$0``Q1$``" 2```A$@.``(A(``",2``#W````````````
M````]P```````````````/<```````````````#W````````````````]P``
M`````````````/<```````````````#W````````````````]P``````````
M`````/<```````````````#W````````````````]P```````````````/<`
M``````````````#W````````````````]P```````````````/<`````````
M``````#W````````````````]P```````````````/<```````````````#W
M````````````````]P```````````````/<```````````````#W````````
M````````]P```````````````/<```````````````#W````````````````
M]P```````````````/(`````````````````````````````````````````
M````! ``9V02$3L```<``!)D4 $!`&=D,AR,```;R \``,D/``#R#P``\P\`
M`/4/``#V#P``+1 ``"X0```O$ ``CA ``(\0``"1$ ``DA ``.P0``#M$ ``
M[A ``!L1```<$0``'A$``!\1``!V$0``=Q$``'@.1``#"$0``PQ$`` ,01``#%
M$0``QA$``/H1``#[$0``_!$``!X2```?$@.``(!(``"(2```C$@.``)1(``"82
M```G$@.``+!(``/?N]^KWZM_W[O?J]^K4]^[WZO?JR?N]^K%O<6RO:F]Q>JE
MH)B1C0``````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````!A9H
MNP<^```,%6B[!SX`%FB[!SX```\5:+L'/@.`6:+L'/@.`^*@.$)%FB[!SX`/BH!
M!A9H$A$[```0%6A!>BP`%FA!>BP`,$H/```5`@.B!`VHQ!0``!@.@.!%FA!>BP`
M50@.!#P-J`````!9H07HL`%4(`086:$%Z+ ``%0((@.0-J+ 0```8(`19H,AR,
M`%4(`14""($#:B$#```&" $6:#(<C !5" $5`@.B!`VI<`@.``!@.@.!%F@.R'(P`
M50@.!!A9H,AR,```0%6@.R'(P`%F@.R'(P`,$H/```/`VH`````%F@.R'(P`50@.!
M`"<C$@.``)!(``"42```F$@.``)Q(``"@.2```I$@.``*A(``"L2` ``L$@.``^@.``
M`````````````/H```````````````#Z````````````````^@.``````````
M`````/@.```````````````#X````````````````^ ```````````````/@.`
M``````````````#X````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````$````$``!G9+L'/@.``"2P`,9!H`1^P@.BX@.L,9!(; (!R*P" <CD* %
M))"@.!26P```7L,0"&+#$`@.R0Q (`````````````````````````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````2 P$``$0`````
M````````````````````````````````````````````````` ```````````
M````````````````````T,GJ>?FZSA&,@.@."J`$NI"P(````#` ```X,GJ>?FZ
MSA&,@.@."J`$NI"]H```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O
M`',`;P!F`'0`+@.!C`&\`;0`O`&0`;P!W`&X`; !O`&$`9 !S`"\`9 !E`'0`
M80!I`&P`<P`N`&$`<P!P`'@.`/P!&`&$`;0!I`&P`>0!)`$0`/0`Y`#8`9@.`W
M`#8`90!D`#<`+0`Y`#8`,P`T`"T`- `S`# `, `M`#D`,0`U`#D`+0`X`#D`
M-@.`S`#@.`9@.`T`&(`- !E`&8`-P`F`&0`:0!S`' `; !A`'D`; !A`&X`9P`]
M`&4`;@.```!$!``!$````````````````````````````````` ```````````
M`````````````````````````````````````````-#)ZGGYNLX1C((`J@.!+
MJ0L"`````P```.#)ZGGYNLX1C((`J@.!+J0N@.````: !T`'0`< `Z`"\`+P!W
M`'<`=P`N`',`<0!L`"T`<P!E`'(`=@.!E`'(`+0!P`&4`<@.!F` &\`<@.!M`&$`
M;@.!C`&4`+@.!C`&\`;0`O`',`<0!L`',`90!R`'8`90!R`#(`, `P`# `7P!C
M`&P`=0!S`'0`90!R`&D`;@.!G`%\`:0!N`',`= !A`&P`; !?`&T`80!I`&X`
M+@.!A`',`< ```,4```!$````````````````````````````````````````
M`````````````````````````````````````````````-#)ZGGYNLX1C((`
MJ@.!+J0L"`````P```.#)ZGGYNLX1C((`J@.!+J0M4````: !T`'0`< `Z`"\`
M+P!S`'4`< !P`&\`<@.!T`"X`;0!I`&,`<@.!O`',`;P!F`'0`+@.!C`&\`;0`O
M`#\`:P!B`&D`9 `]`#,`, `Q`#8`, `P````"P$``$0`````````````````
M````````````````````````````````````````````````` ```````````
M````````T,GJ>?FZSA&,@.@."J`$NI"P(````#````X,GJ>?FZS A&,@.@."J`$NI
M"YH```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O`',`;P!F`'0`
M+@.!C`&\`;0`O`'0`90!C`&@.`;@.!E`'0`+P!P`'(`;P!D`'0`9 0!C`&@.`;@.!O
M`&P`+P!S`'$`; `O`#(`, `P`# `+P!M`&$`:0!N`'0`80!I`&X`+P!F`&$`
M:0!L`&,`; !U`',`+@.!M`',`< !X````!0$``$0`````````````````````
M````````````````````````````````````````````````` ```````````
M````T,GJ>?FZSA&,@.@."J`$NI"P(````#````X,GJ>?FZSA&,@. @."J`$NI"Y0`
M``!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O`',`;P!F`'0`+@.!C
M`&\`;0`O`'0`90!C`&@.`;@.!E`'0`+P!P`'(`;P!D`'0`90!C` &@.`;@.!O`&P`
M+P!S`'$`; `O`#(`, `P`# `+P!D`&4`< !L`&\`>0`O`&@.`80!S`&\`9P`P
M`#$`+@.!M`',`< !X````OP```$0`````````````````````````````````
M````````````````````````````````````````````````` ```T,GJ>?FZ
MSA&,@.@."J`$NI"P(````#````X,GJ>?FZSA&,@.@."J`$NI"TX`` `!H`'0`= !P
M`#H`+P`O`'<`=P!W`"X`;0!C`',`90`N`&T`<P`O`&T`90!S` ',`80!G`&4`
M,0`W`#4`.0`V`#8`- `N`&@.`= !M`&P`````````````````````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` (8"$0`2``$`
MG `/``0````````````$`````````````````````````````````` ``````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M`````````````$ ``$#Q_P(`0 `,! ``````````!@.!.`&\`<@.!M`&$`; ``
M``(````8`$-*& !?2 $$84H8`&U("0AS2 D(=$@.)" ``````````````````
M`````$0`04#R_Z$`1 `,!0``````````%@.!$`&4`9@.!A`'4`; !T`" `4 !A
M`'(`80!G`'(`80!P`&@.`( !&`&\`;@.!T``````!2`&D`\_^S`%(`# 4`````
M``````P`5 !A`&(`; !E`" `3@.!O`'(`;0!A`&P````<`!?V`P``--8&``$*
M`VP`--8&``$%`P``8?8#```"``L````H`&L`]/_!`"@.```4```````````<`
M3@.!O`" `3 !I`',`= ````(`````````-@.!50*(`\0`V``P$```R'(P````)
M`$@.`>0!P`&4`<@.!L`&D`;@.!K````# `^*@.%"*@.)P: ``_P!&`%9 H@.`!`48`
M# 0``#(<C ```!$`1@.!O`&P`; !O`'<`90!D`$@.`>0!P`&4`<@.!L`&D`;@.!K
M````# `^*@.%"*@.QP
`@. ``````+ H```0``" `````_____P````!*````
M2P```%T```!>````O ```+T```"C`0``I $``"0"```E`@.``6 (``%D"``!F
M`@.``9P(``,D"``#*`@.``(P,``"0#``!A`P``8@.,``*4#``"F` P``"@.0```L$
M```Z! ``.P0``(L$``",! ``P 0``,$$```5!0``%@.4``#(%``!@.!0``108`
M`$8&``!'!@.``2 8``(H&``"+!@.``: <``&D'``#T!P``]0<``) (``"1" ``
M'0D``!X)``#$"0``Q0D``" *```A"@.``(@.H``",*```D"@.``)0H``"8*```G
M"@.``* H``"D*```J"@.``*PH``"X*``"8`````# `````````@. ```( `````
M````````F `````P`````````( ```" `````````````)@.`````, ``````
M``" ````@. ````````````"8`````# `````````@. ```( `````````````
MF `````P`````````( ```" `````````````)@.`````, ````````" ````
M@. ````````````"8`````# `````````@. ```( `````````````F `````P
M`````````( ```" `````````````)@.`````, ````````" ````@. ``````
M``````"8`````# `````````@. ```( `````````````F `````P````````
M`( ```" `````````````)@.`````, ````````" ````@. ````````````"8
M`````# `````````@. ```( `````````````F `````P`````````( ```"
M`````````````)@.`````, ````````" ````@. ````````````"8`````# `
M````````@. ```( `````````````F `````P`````````( ```" ````````
M`````)@.`````, ````````" ````@. ````````````"8`````# `````````
M@. ```( `````````````F `````P`````````( ```" `````````````)@.`
M````, ````````" ````@. ````````````"8`````# `````````@. ```( `
M````````````F `````P`````````( ```" `````````````)@.`````, ``
M``````" ````@. ````````````"8`````# `````````@. ```( `````````
M````F `````P`````````( ```" `````````````)@.`````, ````````"
M````@. ````````````"8`````# `````````@. ```( `````````````F ``
M```P`````````( ```" `````````````)@.`````, ````````" ````@. ``
M``````````"8`````# `````````@. ```( `````````````F `````P````
M`````( ```" `````````````)@.`````, ````````" ````@. ``````````
M``"8`````# `````````@. ```( `````````````F `````P`````````( `
M``" `````````````9@.`````, ````````" ````@. ````````````"8````
M`# `````````@. ```( `````````````F `````P`````````( ```" ````
M`````````)@.`````, ````````" ````@. ````````````"8`````# `````
M````@. ```( `````````````F `````P`````````( ```" ````````````
M`)@.`````, ````````" ````@. ````````````"8`````# `````````@. ``
M`( `````````````F `````P`````````( ```" `````````````)@.`````
M, ````````" ````@. ````````````"8`````# `````````@. ```( `````
M````````F `````P`````````( ```" `````````````)@.`````, ``````
M``" ````@. ````````````"8`````# `````````@. ```( `````````````
MF `````P`````````( ```" `````````````)@.`````, ````````" ````
M@. ````````````"8`````# `````````@. ```( `````````````F `````P
M`````````( ```" `````````````)@.`````, ````````" ````@. ``````
M``````"8`````# `````````@. ```( `````````````F `````P````````
M`( ```" `````````````)@.`````, ````````" ````@. ````````````"8
M`````# `````````@. ```( `````````````F `````P`````````( ```"
M`````````````)@.`````, ````````" ````@. ````````````"8`````# `
M````````@. ```( `````````````F `````P`````````( ```" ````````
M`````)@.`````, ````````" ````@. ``````````````````) ,``&$#``!B
M`P``I@.,```H$```+! ``.@.0``#L$``"+! ``C 0``,$$```N"@.``>XD`, `P
M`````````0````0````!````F$)8!WF)`# `, ````````$````#````````
M``````%YB0`P`# ````````!`````@.`````````````!>XD`, ,P````````
M`0````4`````````````!WF)`# #, ````````$````$``````````````%Y
MB0`P`S ````````!`````P`````````````!>XD`, 8P`````````0````4`
M```'````5$58!YI ````, ````````" ````@. ``````````@. =YB0`P"3 `
M```````!````!0`````````````!>8D`, DP`````````0````0`````````
M`````7N)`# *, ````````$````%``````````````<*`````# `````````
M```````&,&0````````'``8``,@./```L$@.``"@.````X`````!@.``BPP``",2
M```L$@.``"P````T````/``````8``"P2```,````BP8```<'``!F!P``:0<`
M`,@.'``#R!P``]0<``"X(``"." ``D0@.``.T(```;"0``'@.D``'<)``#""0``
MQ0D``/L)```>"@.``+ H``!-8%/\5@.!-8%/\5@.!-8%/\5C!-8%/\5@.!-8%/\5
M@.!-8%/\5@. \``/ X```````&\!@.````"" ```@.````$````!`````0````(`
M``! `![Q$ ```/__`````/\`@.(" `/<``! `#P`"\)(````0``CP" ````$`
M```!! ``#P`#\# ````/``3P* ````$`"? 0````````````````````````
M``(`"O (``````0```4````/``3P0@.```!(`"O (`````00````.``!3``OP
M'@.```+\!```0`,L!`````/\!```(``0#"0```#\#`0`!````$? $`````0``
M`/__`@.````T`7P!(`&P`= `Q`# `- `R`#4`,P`R`#$`. `-`%\`2 !L`'0`
M,0`P`#0`,@.`U`#,`,@.`Q`#D`>P@.``'L(```N"@.``````0 $``$![" ``>P@.`
M`"X*````````RP```,\```! !@.``0P8``"X*```'`!P`!P`$``<``````'4"
M``"'`@.``,@.,``$,#```$! ``" 0``#0$```X! ``A00``(D$``"Z! ``O@.0`
M``\%```3!0``30<``%('```N"@.``!P`S``<`,P`'`#,`!P`S` `<`,P`'`#,`
M!P`S``<`,P`'``````!+````70```!8%```Q!0``+@.H```<`! 0`'``4`!P``
M````0 8``$,&```N"@.``!P`$``<``0!!,_5W^&^6F_\/_P__#_\/_P__#_\/
M_P__#Q ``0```````0```````````````````````Q@.```^$T (1A)C^%<8%
M``'0`@.9>A- "8(28_F\H``(````I``$```````$`````````````````` ```
M`! 8```/A* %$828_A7&!0`!H 4&7H2@.!6"$F/Y/2@.``4$H``%%*``!>2@.``
M`@.`!`"D``0````*"`0``````````````````````"A@.```^$< @.1A$S_%<8%
M``%P" 9>A' (8(1,_X=H`````(A(```"``(`+@.`!`````( !````````````
M```````````*& ``#X1 "Q&$F/X5Q@.4``4 +!EZ$0 M@.A)C^AV@.`````B$@.`
M``(``P`N``$````$@. $```````````````````````H8```/A! .$828_A7&
M!0`!$ X&7H00#F"$F/Z': ````"(2 ```@.`$`"X``0````*"`0``````````
M````````````"A@.```^$X! 1A$S_%<8%``'@.$ 9>A. 08(1,_X=H`````(A(
M```"``4`+@.`!`````( !```````````````````````*& ``#X2P$Q&$F/X5
MQ@.4``; 3!EZ$L!-@.A)C^AV@.`````B$@.```(`!@.`N``$````$@. $`````````
M``````````````H8```/A( 6$828_A7&!0`!@.!8&7H2 %F"$F/Z': ````"(
M2 ```@.`'`"X``0````*"`0``````````````````````"A@.```^$ 4!D1A$S_
M%<8%``%0&09>A% 98(1,_X=H`````(A(```"``@.`+@.`!````03/U=P``````
M`````````/_______P$``````/__`0```!(`$0`)"#I<NOT;``D(#P`)"!D`
M"0@.;``D(#P`)"!D`"0@.;``D(&0!V+MH!YS)S"0(``````'![9 7>2HH3`@.``
M````YS)S"0H0#%0!````! `$``X!``#>2HH3W7I&4P$````$``0`#@.$``$@.J
MJ!1D>!TP`@.``````Q'7G%4@.JJ!0#```````"?%H7````````` ````0(``@.`%
M6)D@.+@.)R90$``````)]0KB$````````````!`@.`"`&1X'3!5'J P`0````0`
M! `.`0``51Z@.,)]0KB$!``````"V,'<R-F?_1@.(``````$ 7;#9P>V0%`P``
M````#S%4/[8P=S(#``````#/<() <2L;: $``````#9G_T8%6)D@.`0````0`
M! `.`0``W7I&4P)\6A<!```````*$ Q4!RLG6 $``````"E"0E?/<() `0``
M``0`! `.`0``!RLG6 ````````````$"``(`XTAQ7RE"0E<"``````!^0O9B
M=B[:`0,``````"X"<F4````````````!`@.`"`'$K&V@.`````` ``````!`@.`"
M`)1N.'_C2'%?`P``````7 ````0````(````Y0````````!;````[@.`"`'IU
M"@."7'0T`$500`.-*$0"9&!8`,3 9`$Q_' "49B(`@. <L`$%Z+ `Q!RT`1RTN
M`$@.#,0#0&C(`3%XS`(1>,P#.&CH`$A$[`+L'/@.#O0S\`9#%!`(IS00!?,4D`
M,$5*`*5#30`X/TX`V!E/`%PQ4@.`&<58`)7E7`+HP7 "1*EX`>B-@.`&)+8P#:
M&V4`Z@.YH`"LZ: "^,&X`,@.]P`$\1<0!!%G(`^P5U`/)B@.0`K<80`;4B&`$QN
MA@.`%18<`53"*`#(<C !V'Y(`0T>=`%\FHP!7>*,`QSZE`*HEI@.!C<*8`7B^I
M`)LWJ0!(4JD`\5:I`"\%J@.`0':L`4U:K`*EVL@.#O%[4`$SV[` $D#O #Y+;P`
MZQV^`/U"P !B(L(`C@.+)`+Q&RP#I"<\`SGK0``P]U !8--4`7PG6`-1ZUP`1
M+]D`DVW9`.-UV0#7']T`[4+?`(M^X0`;$>8`7!?G`,8W\@.!7(OD`"P_Z`%Y]
M_@.#_0 . `0!$!@.``1 8``+ VZ (!``$`1 8```````!$!@.````````(0````
M`````"P*``! ```0`$ ``/__`0````<`50!N`&L`;@.!O`'<`;@.#__P$`" ``
M````````````__\!``````#__P```@.#__P````#__P```@.#__ P`````$````
M1Q:0`0```@.(&`P4$!0(#!(=Z`" ```" " ````````#_`0```````%0`:0!M
M`&4`<P`@.`$X`90!W`" `4@.!O`&T`80!N````-1:0`0(`!04!`@.$'!@.(%!P``
M```````0``````````````" `````%,`>0!M`&(`;P!L````,R:0`0```@.L&
M! ("`@.("!(=Z`" ```" " ````````#_`0```````$$`<@.!I`&$`; ```#<F
MD $```(+!@.0#!00$`@.2'`@.`@.````````````````GP$```````!6 `&4`<@.!D
M`&$`;@.!A````(@.`$`'$(B!@.`\- "Y 1H`0````#FF96&G>&:I@.`````&`!T`
M``"$`0``J @.```$`!0````0``Q 2````A $``*@.(```!``4````2````````
M`"$#`/ 0`````0``````````````````````````````````````````` ```
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````@.'H 6T`+0`@.8$R- ``$ `9`&0````9````)PH``"<*````````````
M````````````````````````````````````````````````` ```````````
M```````````"`````````````3*#40#P$ `(````````````````````````
M``````````````!(6 `````H\/\/`0`!/P``Y 0``/___W____]_____?___
M_W____]_____?____W^[!SX``````#(``````````````````````/__$@.``
M``````````````````D`3@.!I`&L`2@.!O`&$`;@.!N`&4`"0!.` &D`:P!*`&\`
M80!N`&X`90```````````````````````````! ````&`````0``````# ``
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````#^_P``!0$"```````````````````````!````X(6?\ OE/:!"KD0@.`
M*R>SV3 ```!@.`0``$ ````$```"(`````@.```) ````#````G ````0```"H
M````!0```+P````'````R ````@.```#<````"0```/ ````2````_ ````H`
M```<`0``# ```"@.!```-````- $```X```! `0``#P```$@.!```0````4 $`
M`!,```!8`0```@.```.0$```>````! `````````>````! `````````>````
M# ```$YI:TIO86YN90```!X````$`````````!X````,````3F]R;6%L+F1O
M= ``'@.````P```!.:6M*;V%N;F4````>````! ```#8````>````& ```$UI
M8W)O<V]F="!/9F9I8V4@.5V]R9 ```$ `````[AX-! ```$ `````U+I,/5S%
M`4 `````=@.2 @.-O%`0,````!`````P```(0!```#````J @.```,`````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````_O\```4!`@.```````````````````````@.````+5S =6<+AL0DY<(
M`"LL^:Y$````!=7-U9PN&Q"3EP@.`*RSYKBP!``#H````# ````$```!H````
M#P```' ````%````? ````8```"$````$0```(P````7````E ````L```"<
M````$ ```*0````3````K ```!8```"T````#0```+P````,````R0````(`
M``#D! ``'@.````0``````````P```!(````#````!0````,````G"@.`` `P``
M`-@.8"P`+``````````L`````````"P`````````+`````````!X0 ```!````
M`0`````,$ ```@.```!X````&````5&ET;&4``P````$`````U 0```,`````
M````( ````$````X`````@.```$ ````!`````@.````P```!?4$E$7TA,24Y+
M4P`"````Y 0``$$```",! ``) ````,```!F`'P``P````\````#````````
M``,````%````'P```"<```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!C`',`
M90`N`&T`<P`O`&T`90!S`',`80!G`&4`,0`W`#4`.0`V`#8`- `N`&@.`= !M
M`&P``````!\````!```````3! ,```!%`$H``P````P````#``````````,`
M```%````'P```$H```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O
M`',`;P!F`'0`+@.!C`&\`;0`O`'0`90!C`&@.`;@.!E`'0`+P!P` '(`;P!D`'0`
M90!C`&@.`;@.!O`&P`+P!S`'$`; `O`#(`, `P`# `+P!D`&4`< !L`&\`>0`O
M`&@.`80!S`&\`9P`P`#$`+@.!M`',`< !X````'P````$``````!,$`P```$L`
M5@.`#````"0````,``````````P````4````?````30```&@.`= !T`' `.@.`O
M`"\`=P!W`'<`+@.!M`&D`8P!R`&\`<P!O`&8`= `N`&,`;P!M`"\`= !E`&,`
M: !N`&4`= `O`' `<@.!O`&0`= !E`&,`: !N`&\`; `O`',`<0!L`"\`,@.`P
M`# `, `O`&T`80!I`&X`= !A`&D`;@.`O`&8`80!I`&P`8P!L`'4`<P`N`&T`
M<P!P`'@.``````!\````!```````3! ,````)`$P``P````8````#````````
M``,````%````'P```"H```!H`'0`= !P`#H`+P`O`',`=0!P`' `;P!R`'0`
M+@.!M`&D`8P!R`&\`<P!O`&8`= `N`&,`;P!M`"\`/P!K`&(`:0!D`#T`,P`P
M`#$`-@.`P`# ````?`````0``````$P0#````< `2``,````#`````P``````
M```#````!0```!\```!0````: !T`'0`< `Z`"\`+P!W`'<`=P`N`',`<0!L
M`"T`<P!E`'(`=@.!E`'(`+0!P`&4`<@.!F`&\`<@.!M`&$`;@.!C` &4`+@.!C`&\`
M;0`O`',`<0!L`',`90!R`'8`90!R`#(`, `P`# `7P!C`&P`=0!S`'0`90!R
M`&D`;@.!G`%\`:0!N`',`= !A`&P`; !?`&T`80!I`&X`+@.!A`',`< ```!\`
M```!```````3! ,``````%\``P`````````#``````````,````%````'P``
M`&T```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O`',`;P!F`'0`
M+@.!C`&\`;0`O`&0`;P!W`&X`; !O`&$`9 !S`"\`9 !E`'0`80!I`&P`<P`N
M`&$`<P!P`'@.`/P!&`&$`;0!I`&P`>0!)`$0`/0`Y`#8`9@.`W`#8`90!D`#<`
M+0`Y`#8`,P`T`"T`- `S`# `, `M`#D`,0`U`#D`+0`X`#D`-@.`S`#@.`9@.`T
M`&(`- !E`&8`-P`F`&0`:0!S`' `; !A`'D`; !A`&X`9P`]`&4`;@.``````
M'P````$``````!,$````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````````$````"`````P````0````%````!@.````<````(` ```"0````H`
M```+````# ````T````.````#P```! ```#^____$@.```!,````4````%0``
M`!8````7````& ```/[___\:````&P```!P````=````'@.```!\````@.````
M(0```"(````C````) ```"4````F````_O___R@.````I````*@.```"L````L
M````+0```"X```#^____, ```#$````R````,P```#0````U````-@.```/[_
M___]____.0```/[____^_____O__________________________________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M________________________________4@.!O`&\`= `@.`$4`;@.!T`'(`>0``
M````````````````````````````````````````````````` ````````!8`
M!0'__________P,````&"0(``````, ```````!&````````````````P*N\
MFH#;Q0$[````@. ````````!$`&$`= !A````````````````````````````
M````````````````````````````````````````````````" @.`"`?______
M_________P``````````````````````````````````````` ````````!$`
M````$ ```````#$`5 !A`&(`; !E````````````````````````````````
M```````````````````````````````````````.``(!`0``` `8```#_____
M````````````````````````````````````````````````& 0```&4:````
M````5P!O`'(`9 !$`&\`8P!U`&T`90!N`'0`````````````````````````
M`````````````````````````````!H``@.$"````!0```/____\`````````
M````````````````````````````````````````````+B ````````%`%,`
M=0!M`&T`80!R`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N````` ```````````
M````````````````````* `"`?_______________P``````````````````
M`````````````````````````````"<`````$ ````````4`1 !O`&,`=0!M
M`&4`;@.!T`%,`=0!M`&T`80!R`'D`20!N`&8`;P!R`&T`80!T` &D`;P!N````
M```````````X``(!! ```/__________````````````````````````````
M````````````````````+P`````0`````````0!#`&\`;0!P` $\`8@.!J````
M````````````````````````````````````````````````` ```````````
M`!(``@.#_______________\`````````````````````````` ```````````
M````````````````<0``````````````````````````````` ```````````
M````````````````````````````````````````````````` ````````/__
M_____________P``````````````````````````````````` ```````````
M``````````````````$```#^_________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M________________________________________`0#^_P,*` `#_____!@.D"
M``````# ````````1A\```!-:6-R;W-O9G0@.3V9F:6-E(%=O<F0@.1&]C=6UE
M;G0`"@.```$U35V]R9$1O8P`0````5V]R9"Y$;V-U;65N="XX`/0YLG$`````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
"````
`
end
|||Hello Nick,
I think you forgot to post the links..?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> These are my notes with links at the end.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:C8CEA952-209A-41BF-8C85-F4473964CE62@.microsoft.com...
>
>
|||They are the blue hyperlinks in the word document I attached (last page).
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:D4C201FF-5E36-42B0-9FF2-C319E11CC07A@.microsoft.com...[vbcol=seagreen]
> Hello Nick,
> I think you forgot to post the links..?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
|||Nik,
I am sorry if I have used the wrong terms when asking the question.
I am very well acquainted with the MS Cluster Services but I am no expert on
SQL, I admit that, even if I have clustered a few by now.
In an SQL 2000 clusterinstallation, the logs will default reside on the same
shared drive as the db:s. Oracle (of which I also have done several succesful
cluster installations) recommend to put the log files on one or several local
disks, of security and performance reasons.
So, I ask you the question again:
Does Microsoft recommend the same ?
Directing the logfiles on local disks and separate from the O.S. ?
Or maybe on another shared drive than the DB:s ?
If the latter one is suggested, what is the impact on the "SQL function" if
the group with the logfiles would suddenly change ownership ?
I cannot find any documentation or MS recommendations on where to put these
logfiles.
Could you please clarify this, Nik and enlighten me ?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> Failover does not occur for disks just the computer itself. You have a
> shared disk resource(s) which 1 node in the cluster owns. Should that node
> fail then another will take over ownership of the disk resources. It sounds
> like you require fault tolerant hardware. I siggest to re-read all the links
> so you better understand clustering and what it provides.
> And log file placement is usually decided by performance resons.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:1B59D480-E4F9-40F1-8609-CD7CC07DC331@.microsoft.com...
>
>
|||Putting logfiles on seperate drives is a performance issue. RAID-5 is
striped with paraity so it effectively spreads the IO over several physical
drives anyway. If you do not have performance issues then placing the drives
on the same shared drive as the data files is fine. You cannot put the
logfiles on local drives they must reside on a shared drive so the
opwnership can change. There are no issues with change of ownership. If node
1 fails then SQL is shutdown on that node the disks change ownership to the
other node and SQL starts on that node owning the same data that was being
used on the first node.
I hope this clarifies things for you.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:A2DE7B47-17C2-4BF8-81E4-14CF9D4273ED@.microsoft.com...[vbcol=seagreen]
> Nik,
> I am sorry if I have used the wrong terms when asking the question.
> I am very well acquainted with the MS Cluster Services but I am no expert
> on
> SQL, I admit that, even if I have clustered a few by now.
> In an SQL 2000 clusterinstallation, the logs will default reside on the
> same
> shared drive as the db:s. Oracle (of which I also have done several
> succesful
> cluster installations) recommend to put the log files on one or several
> local
> disks, of security and performance reasons.
> So, I ask you the question again:
> Does Microsoft recommend the same ?
> Directing the logfiles on local disks and separate from the O.S. ?
> Or maybe on another shared drive than the DB:s ?
> If the latter one is suggested, what is the impact on the "SQL function"
> if
> the group with the logfiles would suddenly change ownership ?
> I cannot find any documentation or MS recommendations on where to put
> these
> logfiles.
> Could you please clarify this, Nik and enlighten me ?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
|||Nik,
Actually, not quite.
One of the main reasons to put the logfiles on local disks in an Oracle
cluster environment is
that if the shared disk with the db:s totally fails, I am able to recover
the db:s anyway from the logfiles.
According to your statement, I am not able use local drives to put the SQL
logfiles.
To put them in another cluster group and consequently on another drive would
then not be possible either since the node that owns the SQL-db:s HAS to be
able to write to the disk with the logfiles. And if the shared disk with the
logfiles is owned by the other node...
You see what I mean here ?
My conclusion of our discussion is that I HAVE to place the logfiles on the
same shared disk as the SQL-db:s .
Do you agree, Nik ?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> Putting logfiles on seperate drives is a performance issue. RAID-5 is
> striped with paraity so it effectively spreads the IO over several physical
> drives anyway. If you do not have performance issues then placing the drives
> on the same shared drive as the data files is fine. You cannot put the
> logfiles on local drives they must reside on a shared drive so the
> opwnership can change. There are no issues with change of ownership. If node
> 1 fails then SQL is shutdown on that node the disks change ownership to the
> other node and SQL starts on that node owning the same data that was being
> used on the first node.
> I hope this clarifies things for you.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:A2DE7B47-17C2-4BF8-81E4-14CF9D4273ED@.microsoft.com...
>
>
|||I see what you're driving at but you CAN have 2 seperate disk groups and set
the dependancies accordingy such that if one group changes then so must the
other group.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:F39B4B53-BE89-4AF0-836C-8846CAA9AE93@.microsoft.com...[vbcol=seagreen]
> Nik,
> Actually, not quite.
> One of the main reasons to put the logfiles on local disks in an Oracle
> cluster environment is
> that if the shared disk with the db:s totally fails, I am able to recover
> the db:s anyway from the logfiles.
> According to your statement, I am not able use local drives to put the SQL
> logfiles.
> To put them in another cluster group and consequently on another drive
> would
> then not be possible either since the node that owns the SQL-db:s HAS to
> be
> able to write to the disk with the logfiles. And if the shared disk with
> the
> logfiles is owned by the other node...
> You see what I mean here ?
> My conclusion of our discussion is that I HAVE to place the logfiles on
> the
> same shared disk as the SQL-db:s .
> Do you agree, Nik ?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
|||Are you sure ?
I have never seen any documents describing dependencies BETWEEN groups.
Only WITHIN groups.
If this is possible, why is it so poorly documented ?
You don′t happen to have any ?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> I see what you're driving at but you CAN have 2 seperate disk groups and set
> the dependancies accordingy such that if one group changes then so must the
> other group.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:F39B4B53-BE89-4AF0-836C-8846CAA9AE93@.microsoft.com...
>
>
|||Oops Sunday rest day head got me there.
You are right, I meant resources, You can create another disk resource for
the logfiles within the same group and make the logfile resource dependacies
suc that they will always swap ownership with the main db resource group. I
can't see why you'd want a seperate group for the logfiles though, another
logfile resource within the same group would be sufficient.
I've re-read your posts to try to make sure I undertand your requirements
and I think I've done that. If you think I've misunderstood or not explaied
cleary enough please post it.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:FB5EFBD5-07FA-4BF4-B537-631244748912@.microsoft.com...[vbcol=seagreen]
> Are you sure ?
> I have never seen any documents describing dependencies BETWEEN groups.
> Only WITHIN groups.
> If this is possible, why is it so poorly documented ?
> You dont happen to have any ?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
I one clusternode fails. What is the procedure to reinstall the SQL software
INCLUDING SQL servicepacks? Preferrably without disturbing the remaining
node. Documents anyone ?
Also, SQL-logs, where could or should they reside ? On the same shared disk
as the db:s or on another one? Or maybe on a local disk ?
Regards
Johnny Lundgren
These are my notes with links at the end.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:C8CEA952-209A-41BF-8C85-F4473964CE62@.microsoft.com...
> Hello,
> I one clusternode fails. What is the procedure to reinstall the SQL
> software
> INCLUDING SQL servicepacks? Preferrably without disturbing the remaining
> node. Documents anyone ?
> Also, SQL-logs, where could or should they reside ? On the same shared
> disk
> as the db:s or on another one? Or maybe on a local disk ?
> Regards
> Johnny Lundgren
begin 666 Cluster.doc
MT,\1X*&Q&N$`````````````````````/@.`#`/[_"0`&```````````````!
M````. ``````````$ ``.@.````$```#^____`````#<```#_____________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_______________________LI<$`?V )! ``^!*_````````$ ``````!@.``
M+!(```X`8FIB:N:'YH<````````````````````````)!!8`+ B ``(3M``"$
M[0``+ H```````````````````````````````````````#__P\````` ````
M``#__P\```````````#__P\``````````````````````*0`` ````"0$````
M````) 0``"0$````````) 0````````D! ```````"0$````````) 0``!0`
M`````````````#@.$````````H T```````"@.#0```````* -````````H T`
M`!0```"T#0``' ```#@.$````````L18``.X```#<#0``< ```$P.````````
M3 X```````!,#@.```````$P.````````)P\``#X```!E#P``% ```'D/```,
M````,!8```(````R%@.```````#(6````````,A8````````R% @.```````#(6
M````````,A8``"0```"?%P``: (```<:``!.````5A8``!4`````````````
M````````````) 0```````"%#P`````````````````````````````G#P``
M`````"</````````A0\```````"%#P```````%86`````````````````` `D
M! ```````"0$````````3 X``````````````````$P.``#;````:Q8``!8`
M``!)$ ```````$D0````````21 ```````"%#P``(@.```"0$````````3 X`
M```````D! ```````$P.````````,!8``````````````````$D0````````
M````````````````````````````````````````````````` ```````````
M````A0\````````P%@.``````````````````21 ```````!)$ ``'@.```,H2
M```8````) 0````````D! ``````````````````````````````````````
M````````````````````````````````````````````%A,`` `````!,#@.``
M`````- -```,````X%.NFH#;Q0$``````````* -````````IP\``&H```#B
M$@.``" ``````````````,!8```````"!%@.``, ```+$6````````ZA(``"P`
M``!5&@.```````!$0```B````51H``! ````6$P``````````````````````
M````````````````````````````````````````````````` ```````````
M```````````6$P``D@.$``%4:```````````````````D! ```````*@.4``"(
M`0``A0\```````"%#P```````$D0````````A0\```````"%# P``````````
M````````````````````````````````````````A0\`````` `"%#P``````
M`(4/````````5A8```````!6%@.```````````````````````````` ``````
M````````````````,Q ``!8`````````````````````````````````````
M`````````(4/````````A0\```````"%#P```````+$6````````A0\`````
M``"%#P```````(4/````````A0\``````````````````#@.$````````. 0`
M```````X! ``Y <``!P,``"$`0``. 0````````X! ```````#@.$````````
M' P````````X! ```````#@.$````````. 0````````D! ```````"0$````
M````) 0````````D! ```````"0$````````) 0```````#_____``````(`
M# $````````````````````````````````````````````````` ````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ````%=I;F1O
M=W,@.,C P,R!C;'5S=&5R(&EN<W1A;&QA=&EO;B]F86EL=7)E+V5V:6-T:6]N
M+V%D9"!397)V:6-E('!A8VL@.;F]T97,-#5-13"!397)V:6-E(%!A8VMS#0U"
M969O<F4@.87!P;'EI;F<@.86YY('-E<G9I8V4@.<&%C:W,@.<')E<&%R92!A(&-O
M;G1I;F=E;F-Y('!L86X@.:6X@.8V%S92!O9B!C871A<W1R;W!H:6,@.9F%I;'5R
M92X-#4UA:V4@.<W5R92!T:&4@.;7-D8BP@.;6%S=&5R(&%N9"!M;V1E;"!D871A
M8F%S97,@.87)E(&)A8VME9"!U<"!T;R!A('-T;W)A9V4@.;65D:6$@.;F]T(&1E
M<&5N9&%N="!O;B!T:&4@.8VQU<W1E<B!B96EN9R!U<&=R861E9 "X@.268@.4U T
M(&EN<W1A;&QA=&EO;B!F86EL<R!T:&5N('1H97-E(&1A=&%B87-E<R!W:6QL
M(&AA=F4@.=&\@.8F4@.<F5S=&]R960@.8F5C875S92!T:&5Y(&%R92!A;65N9&5D
M(&)Y(%-0-"X-#4UA:V4@.<W5R92!Y;W4@.:&%V92!C=7)R96YT(&)A8VMU<',@.
M;V8@.87!P;&EC871I;VX@.9&%T86)A<V5S(&%G86EN(&YO="!O; B!S=&]R86=E
M(&UE9&EA(&1E<&5N9&%N="!O;B!T:&4@.8VQU<W1E<B!B96EN9 R!U<&=R861E
M9"X-#4UA:V4@.<W5R92!T:&%T(%-0,R!I<R!A<'!L:65D(&)E9F]R92!A<'!L
M>6EN9R!34#0N#0U.;V1E($9A:6QU<F4-#55S:6YG(&-L=7-T97(@.861M:6YI
M<W1R871O<B!S=&]P('1H92!C;'5S=&5R('-E<G9I8V4@.;VX@.=&AE(&9A:6QE
M9"!N;V1E(&%N9"!E=FEC="!T:&4@.9F%I;&5D(&YO9&4-#5)E8G5I;&0@.=&AE
M('-E<G9E<B!W:71H('1H92!H;W-T($]3(&%N9"!S86UE('-E<G9I8V4@.<&%C
M:R!A<R!O=&AE<B!N;V1E<R!I;B!T:&4@.8VQU<W1E<BX-#55S:6YG(&-L=7-T
M97(@.861M:6YI<W1R871O<B!A9&0@.=&AE(&YE=R!N;V1E('1O( '1H92!C;'5S
M=&5R+@.T-57-I;F<@.=&AE(%-13"!I;G-T86QL871I;VX@.0T0O9&ES:R!C;W!Y
M(')U;B!T:&4@.4U%,(&EN<W1A;&QA=&EO;BX@.#0U/;B!T:&4@.0V]M<'5T97(@.
M3F%M92!P86=E+"!T>7!E('1H92!V:7)T=6%L('-E<G9E<B!N86UE+"!C;&EC
M:R!6:7)T=6%L(%-E<G9E<BP@.86YD('1H96X@.8VQI8VL@.3F5X="X-#4QE879I
M;F<@.061V86YC960@.3W!T:6]N<R!S96QE8W1E9"P@.8VQI8VL@.3F5X="X-#4QE
M879I;F<@.36%I;G1A:6X@.82!6:7)T=6%L(%-E<G9E<B!F;W(@.1F%I;&]V97(@.
M0VQU<W1E<FEN9R!S96QE8W1E9"P@.8VQI8VL@.3F5X="X-#4]N('1H92!6:7)T
M=6%L(%-E<G9E<B!);F9O<FUA=&EO;B!P86=E+"!C;&EC:R!.97AT+@.T-3VX@.
M=&AE($-L=7-T97(@.36%N86=E;65N="!P86=E+"!C;&EC:R!T:&4@.;F5W(&YO
M9&4L(&-L:6-K($%D9"P@.86YD('1H96X@.8VQI8VL@.3F5X="X-#45N=&5R('1H
M92!R96QE=F%N="!D971A:6QS+@.U!<'!L>2!344P@.4U S('!H>7-I8V%L;'D@.
M;VX@.=&AE(')E8G5I;'0@.;F]D92X-07!P;'D@.4U T('1O('1H92!O=&AE<B H
M;F]N+69A:6QE9"D@.;F]D92 H979E;B!I9B!I="!H87,@.86QR96%D>2!B965N
M(&%P<&QI960I+B!4:&ES('=I;&P@.87!P;'D@.4U T('1O(&)O=&@.@.;F]D97,@.
M8G)I;F=I;F<@.=&AE;2!I;B!L:6YE+B!9;W4@.;6%Y(&YE960@.= &\@.9&5L971E
M($Y%141?4U!?2T59(&9R;VT@.=&AE(')E9VES=')Y(&]F(&)O=&@.@.8V]M<'5T
M97)S(&)E9F]R92!A<'!L>6EN9R!34#0N#0T-#51H92!F;VQL;W=I;F<@.;&EN
M:W,@.<')O=FED92!A;&P@.=&AE(&EN9F]R;6%T:6]N('1H870@.:7,@.<F5Q=6ER
M960N#0T3($A94$523$E.2R B:'1T<#HO+W=W=RYM:6-R;W-O9G0N8V]M+V1O
M=VYL;V%D<R]D971A:6QS+F%S<'@._1F%M:6QY240].39F-S9E9#<M.38S-"TT
M,S P+3DQ-3DM.#DV,SAF-&(T968W)F1I<W!L87EL86YG/65N(B !%$1O=VYL
M;V%D(&1E=&%I;',Z($=U:61E('1O($-R96%T:6YG(&%N9"!#;VYF:6=U<FEN
M9R!A(%-E<G9E<B!#;'5S=&5R(%5N9&5R(%=I;F1O=W,@.4V5R=F5R(#(P, #,5
M#0T3($A94$523$E.2R B:'1T<#HO+W=W=RYS<6PM<V5R=F5R+7!E<F9O<FUA
M;F-E+F-O;2]S<6QS97)V97(R,# P7V-L=7-T97)I;F=?:6YS=&%L;%]M86EN
M+F%S<"(@.`11(;W<@.=&\@.26YS=&%L;"!344P@.4V5R=F5R(#(P, # @.0VQU<W1E
M<FEN9Q4-#1,@.2%E015),24Y+(")H='1P.B\O<W5P<&]R="YM:6-R;W-O9G0N
M8V]M+S]K8FED/3,P,38P,"(@.`11(;W<@.=&\@.8V]N9FEG=7)E($UI8W)O<V]F
M="!$:7-T<FEB=71E9"!4<F%N<V%C=&EO;B!#;V]R9&EN871O<B!O;B!A(%=I
M;F1O=W,@.4V5R=F5R(#(P,#,@.8VQU<W1E<A4-#1,@.2%E015),24Y+(")H='1P
M.B\O=W=W+FUI8W)O<V]F="YC;VTO=&5C:&YE="]P<F]D=&5C:&YO;"]S<6PO
M,C P,"]M86EN=&%I;B]F86EL8VQU<RYM<W!X(B !%$UI8W)O<V]F="!344P@.
M4V5R=F5R(#(P,# @.1F%I;&]V97(@.0VQU<W1E<FEN9Q4-#1,@.2%E015),24Y+
M(")H='1P.B\O=W=W+FUI8W)O<V]F="YC;VTO=&5C:&YE="]P<F]D=&5C:&YO
M;"]S<6PO,C P,"]D97!L;WDO:&%S;V<P,2YM<W!X(B !%%-13"!397)V97(@.
M,C P,"!(:6=H($%V86EL86)I;&ET>2!397)I97,Z($EM<&QE;65N= &EN9R!&
M86EL;W9E<B!#;'5S=&5R:6YG%0T-$R!(65!%4DQ)3DL@.(FAT=' Z+R]W=W<N
M;6-S92YM<R]M97-S86=E,3<U.38V-"YH=&UL(B !%$%D9&EN9R!N97<@.;F]D
M92!T;R!344P@.4U T(&-L=7-T97(5#0T-#0T-#0T-#0T-#0``````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M```````````&``!)" ``2@.@.``$L(``!/" ``7 @.``%X(``!F" ``60H``&4*
M``!G"@.``CPH``+0*```""P``%0L``"0+``"D"P``I@.L``*T+` `"Z"P``Y0L`
M`/,+```$# ``" P``!,,```C# ``- P``#@.,``!## ``= P``(4,``")# ``
MDPP``*T,``"Z# ``O@.P``,@.,``#:# ``^PP``/X,```/#0``$PT``!4-```6
M#0``Z T``$0.``"+#@.``C X```8/```'#P``" \``&8/``!G#P``:0\``&H/
M``#'#P``R \``/?OZ^;WYM_K]^;KV^O7Z]?;T,;0QM#&T,;0QM#&T,;0QM#&
MT,;0QM#&T+K;MMNNVZ.NFJ[;KMN/```5`@.B!`VI+`0``!@.@.!%F@.R'(P`50@.!
M$!5H,AR,`!9H,AR,`#!*#P``%0((@.0-J``````8(`19H,AR,`%4(`0\#:@.``
M```6:#(<C !5" $&%FCJ#F@.``!86:#(<C !#2A$`3TH#`%%*`P!A2A$``!(5
M:#(<C `6:#(<C `U"(%<"($`#!5H,AR,`!9H,AR,```&%F@.2$3L```86:#(<
MC ``#!5HNP<^`!9HNP<^```)%FB[!SX`/BH!!A9HNP<^```/%6B[!SX`%FA#
M1YT`/BH!#Q5HNP<^`!9HNP<^`#XJ`0`X``8``$H(``!+" ``70@.``%X(``"\
M" ``O0@.``*,)``"D"0``) H``"4*``!8"@.``60H``&8*``!G"@.``R0H``,H*
M```C"P``) L``&$+``!B"P``I0L``*8+```*# ``"PP``#H,```[# ``BPP`
M`/T```````````````#]````````````````_0```````````````/T`````
M``````````#X````````````````^ ```````````````/@.`````````````
M``#X````````````````^ ```````````````/@.```````````````#X````
M````````````^ ```````````````/@.```````````````#X````````````
M````^ ```````````````/@.```````````````#X````````````````\P``
M`````````````/,```````````````#S````````````````ZP``````````
M`````.L```````````````#K````````````````ZP``````` ````````.L`
M``````````````#K````````````````ZP``````````````` ```````````
M!P``$F10`0$`9V0R'(P```0``&=D$A$[```$``!G9+L'/@.```0```!L`!@.``
M+!(``/T````````````````````````````````````````````````` ````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````````0$``$!`8L,``",# ``P P``,$,```5#0``%@.T``#(-``!@.#0``
M10X``$8.``!'#@.``2 X``(H.``"+#@.``: \``&D/``#T#P``]0\``) 0``"1
M$ ``'1$``!X1``#$$0``Q1$``" 2```A$@.``(A(``",2``#W````````````
M````]P```````````````/<```````````````#W````````````````]P``
M`````````````/<```````````````#W````````````````]P``````````
M`````/<```````````````#W````````````````]P```````````````/<`
M``````````````#W````````````````]P```````````````/<`````````
M``````#W````````````````]P```````````````/<```````````````#W
M````````````````]P```````````````/<```````````````#W````````
M````````]P```````````````/<```````````````#W````````````````
M]P```````````````/(`````````````````````````````````````````
M````! ``9V02$3L```<``!)D4 $!`&=D,AR,```;R \``,D/``#R#P``\P\`
M`/4/``#V#P``+1 ``"X0```O$ ``CA ``(\0``"1$ ``DA ``.P0``#M$ ``
M[A ``!L1```<$0``'A$``!\1``!V$0``=Q$``'@.1``#"$0``PQ$`` ,01``#%
M$0``QA$``/H1``#[$0``_!$``!X2```?$@.``(!(``"(2```C$@.``)1(``"82
M```G$@.``+!(``/?N]^KWZM_W[O?J]^K4]^[WZO?JR?N]^K%O<6RO:F]Q>JE
MH)B1C0``````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````!A9H
MNP<^```,%6B[!SX`%FB[!SX```\5:+L'/@.`6:+L'/@.`^*@.$)%FB[!SX`/BH!
M!A9H$A$[```0%6A!>BP`%FA!>BP`,$H/```5`@.B!`VHQ!0``!@.@.!%FA!>BP`
M50@.!#P-J`````!9H07HL`%4(`086:$%Z+ ``%0((@.0-J+ 0```8(`19H,AR,
M`%4(`14""($#:B$#```&" $6:#(<C !5" $5`@.B!`VI<`@.``!@.@.!%F@.R'(P`
M50@.!!A9H,AR,```0%6@.R'(P`%F@.R'(P`,$H/```/`VH`````%F@.R'(P`50@.!
M`"<C$@.``)!(``"42```F$@.``)Q(``"@.2```I$@.``*A(``"L2` ``L$@.``^@.``
M`````````````/H```````````````#Z````````````````^@.``````````
M`````/@.```````````````#X````````````````^ ```````````````/@.`
M``````````````#X````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````$````$``!G9+L'/@.``"2P`,9!H`1^P@.BX@.L,9!(; (!R*P" <CD* %
M))"@.!26P```7L,0"&+#$`@.R0Q (`````````````````````````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````2 P$``$0`````
M````````````````````````````````````````````````` ```````````
M````````````````````T,GJ>?FZSA&,@.@."J`$NI"P(````#` ```X,GJ>?FZ
MSA&,@.@."J`$NI"]H```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O
M`',`;P!F`'0`+@.!C`&\`;0`O`&0`;P!W`&X`; !O`&$`9 !S`"\`9 !E`'0`
M80!I`&P`<P`N`&$`<P!P`'@.`/P!&`&$`;0!I`&P`>0!)`$0`/0`Y`#8`9@.`W
M`#8`90!D`#<`+0`Y`#8`,P`T`"T`- `S`# `, `M`#D`,0`U`#D`+0`X`#D`
M-@.`S`#@.`9@.`T`&(`- !E`&8`-P`F`&0`:0!S`' `; !A`'D`; !A`&X`9P`]
M`&4`;@.```!$!``!$````````````````````````````````` ```````````
M`````````````````````````````````````````-#)ZGGYNLX1C((`J@.!+
MJ0L"`````P```.#)ZGGYNLX1C((`J@.!+J0N@.````: !T`'0`< `Z`"\`+P!W
M`'<`=P`N`',`<0!L`"T`<P!E`'(`=@.!E`'(`+0!P`&4`<@.!F` &\`<@.!M`&$`
M;@.!C`&4`+@.!C`&\`;0`O`',`<0!L`',`90!R`'8`90!R`#(`, `P`# `7P!C
M`&P`=0!S`'0`90!R`&D`;@.!G`%\`:0!N`',`= !A`&P`; !?`&T`80!I`&X`
M+@.!A`',`< ```,4```!$````````````````````````````````````````
M`````````````````````````````````````````````-#)ZGGYNLX1C((`
MJ@.!+J0L"`````P```.#)ZGGYNLX1C((`J@.!+J0M4````: !T`'0`< `Z`"\`
M+P!S`'4`< !P`&\`<@.!T`"X`;0!I`&,`<@.!O`',`;P!F`'0`+@.!C`&\`;0`O
M`#\`:P!B`&D`9 `]`#,`, `Q`#8`, `P````"P$``$0`````````````````
M````````````````````````````````````````````````` ```````````
M````````T,GJ>?FZSA&,@.@."J`$NI"P(````#````X,GJ>?FZS A&,@.@."J`$NI
M"YH```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O`',`;P!F`'0`
M+@.!C`&\`;0`O`'0`90!C`&@.`;@.!E`'0`+P!P`'(`;P!D`'0`9 0!C`&@.`;@.!O
M`&P`+P!S`'$`; `O`#(`, `P`# `+P!M`&$`:0!N`'0`80!I`&X`+P!F`&$`
M:0!L`&,`; !U`',`+@.!M`',`< !X````!0$``$0`````````````````````
M````````````````````````````````````````````````` ```````````
M````T,GJ>?FZSA&,@.@."J`$NI"P(````#````X,GJ>?FZSA&,@. @."J`$NI"Y0`
M``!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O`',`;P!F`'0`+@.!C
M`&\`;0`O`'0`90!C`&@.`;@.!E`'0`+P!P`'(`;P!D`'0`90!C` &@.`;@.!O`&P`
M+P!S`'$`; `O`#(`, `P`# `+P!D`&4`< !L`&\`>0`O`&@.`80!S`&\`9P`P
M`#$`+@.!M`',`< !X````OP```$0`````````````````````````````````
M````````````````````````````````````````````````` ```T,GJ>?FZ
MSA&,@.@."J`$NI"P(````#````X,GJ>?FZSA&,@.@."J`$NI"TX`` `!H`'0`= !P
M`#H`+P`O`'<`=P!W`"X`;0!C`',`90`N`&T`<P`O`&T`90!S` ',`80!G`&4`
M,0`W`#4`.0`V`#8`- `N`&@.`= !M`&P`````````````````````````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` (8"$0`2``$`
MG `/``0````````````$`````````````````````````````````` ``````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M`````````````$ ``$#Q_P(`0 `,! ``````````!@.!.`&\`<@.!M`&$`; ``
M``(````8`$-*& !?2 $$84H8`&U("0AS2 D(=$@.)" ``````````````````
M`````$0`04#R_Z$`1 `,!0``````````%@.!$`&4`9@.!A`'4`; !T`" `4 !A
M`'(`80!G`'(`80!P`&@.`( !&`&\`;@.!T``````!2`&D`\_^S`%(`# 4`````
M``````P`5 !A`&(`; !E`" `3@.!O`'(`;0!A`&P````<`!?V`P``--8&``$*
M`VP`--8&``$%`P``8?8#```"``L````H`&L`]/_!`"@.```4```````````<`
M3@.!O`" `3 !I`',`= ````(`````````-@.!50*(`\0`V``P$```R'(P````)
M`$@.`>0!P`&4`<@.!L`&D`;@.!K````# `^*@.%"*@.)P: ``_P!&`%9 H@.`!`48`
M# 0``#(<C ```!$`1@.!O`&P`; !O`'<`90!D`$@.`>0!P`&4`<@.!L`&D`;@.!K
M````# `^*@.%"*@.QP
`@. ``````+ H```0``" `````_____P````!*````M2P```%T```!>````O ```+T```"C`0``I $``"0"```E`@.``6 (``%D"``!F
M`@.``9P(``,D"``#*`@.``(P,``"0#``!A`P``8@.,``*4#``"F` P``"@.0```L$
M```Z! ``.P0``(L$``",! ``P 0``,$$```5!0``%@.4``#(%``!@.!0``108`
M`$8&``!'!@.``2 8``(H&``"+!@.``: <``&D'``#T!P``]0<``) (``"1" ``
M'0D``!X)``#$"0``Q0D``" *```A"@.``(@.H``",*```D"@.``)0H``"8*```G
M"@.``* H``"D*```J"@.``*PH``"X*``"8`````# `````````@. ```( `````
M````````F `````P`````````( ```" `````````````)@.`````, ``````
M``" ````@. ````````````"8`````# `````````@. ```( `````````````
MF `````P`````````( ```" `````````````)@.`````, ````````" ````
M@. ````````````"8`````# `````````@. ```( `````````````F `````P
M`````````( ```" `````````````)@.`````, ````````" ````@. ``````
M``````"8`````# `````````@. ```( `````````````F `````P````````
M`( ```" `````````````)@.`````, ````````" ````@. ````````````"8
M`````# `````````@. ```( `````````````F `````P`````````( ```"
M`````````````)@.`````, ````````" ````@. ````````````"8`````# `
M````````@. ```( `````````````F `````P`````````( ```" ````````
M`````)@.`````, ````````" ````@. ````````````"8`````# `````````
M@. ```( `````````````F `````P`````````( ```" `````````````)@.`
M````, ````````" ````@. ````````````"8`````# `````````@. ```( `
M````````````F `````P`````````( ```" `````````````)@.`````, ``
M``````" ````@. ````````````"8`````# `````````@. ```( `````````
M````F `````P`````````( ```" `````````````)@.`````, ````````"
M````@. ````````````"8`````# `````````@. ```( `````````````F ``
M```P`````````( ```" `````````````)@.`````, ````````" ````@. ``
M``````````"8`````# `````````@. ```( `````````````F `````P````
M`````( ```" `````````````)@.`````, ````````" ````@. ``````````
M``"8`````# `````````@. ```( `````````````F `````P`````````( `
M``" `````````````9@.`````, ````````" ````@. ````````````"8````
M`# `````````@. ```( `````````````F `````P`````````( ```" ````
M`````````)@.`````, ````````" ````@. ````````````"8`````# `````
M````@. ```( `````````````F `````P`````````( ```" ````````````
M`)@.`````, ````````" ````@. ````````````"8`````# `````````@. ``
M`( `````````````F `````P`````````( ```" `````````````)@.`````
M, ````````" ````@. ````````````"8`````# `````````@. ```( `````
M````````F `````P`````````( ```" `````````````)@.`````, ``````
M``" ````@. ````````````"8`````# `````````@. ```( `````````````
MF `````P`````````( ```" `````````````)@.`````, ````````" ````
M@. ````````````"8`````# `````````@. ```( `````````````F `````P
M`````````( ```" `````````````)@.`````, ````````" ````@. ``````
M``````"8`````# `````````@. ```( `````````````F `````P````````
M`( ```" `````````````)@.`````, ````````" ````@. ````````````"8
M`````# `````````@. ```( `````````````F `````P`````````( ```"
M`````````````)@.`````, ````````" ````@. ````````````"8`````# `
M````````@. ```( `````````````F `````P`````````( ```" ````````
M`````)@.`````, ````````" ````@. ``````````````````) ,``&$#``!B
M`P``I@.,```H$```+! ``.@.0``#L$``"+! ``C 0``,$$```N"@.``>XD`, `P
M`````````0````0````!````F$)8!WF)`# `, ````````$````#````````
M``````%YB0`P`# ````````!`````@.`````````````!>XD`, ,P````````
M`0````4`````````````!WF)`# #, ````````$````$``````````````%Y
MB0`P`S ````````!`````P`````````````!>XD`, 8P`````````0````4`
M```'````5$58!YI ````, ````````" ````@. ``````````@. =YB0`P"3 `
M```````!````!0`````````````!>8D`, DP`````````0````0`````````
M`````7N)`# *, ````````$````%``````````````<*`````# `````````
M```````&,&0````````'``8``,@./```L$@.``"@.````X`````!@.``BPP``",2
M```L$@.``"P````T````/``````8``"P2```,````BP8```<'``!F!P``:0<`
M`,@.'``#R!P``]0<``"X(``"." ``D0@.``.T(```;"0``'@.D``'<)``#""0``
MQ0D``/L)```>"@.``+ H``!-8%/\5@.!-8%/\5@.!-8%/\5C!-8%/\5@.!-8%/\5
M@.!-8%/\5@. \``/ X```````&\!@.````"" ```@.````$````!`````0````(`
M``! `![Q$ ```/__`````/\`@.(" `/<``! `#P`"\)(````0``CP" ````$`
M```!! ``#P`#\# ````/``3P* ````$`"? 0````````````````````````
M``(`"O (``````0```4````/``3P0@.```!(`"O (`````00````.``!3``OP
M'@.```+\!```0`,L!`````/\!```(``0#"0```#\#`0`!````$? $`````0``
M`/__`@.````T`7P!(`&P`= `Q`# `- `R`#4`,P`R`#$`. `-`%\`2 !L`'0`
M,0`P`#0`,@.`U`#,`,@.`Q`#D`>P@.``'L(```N"@.``````0 $``$![" ``>P@.`
M`"X*````````RP```,\```! !@.``0P8``"X*```'`!P`!P`$``<``````'4"
M``"'`@.``,@.,``$,#```$! ``" 0``#0$```X! ``A00``(D$``"Z! ``O@.0`
M``\%```3!0``30<``%('```N"@.``!P`S``<`,P`'`#,`!P`S` `<`,P`'`#,`
M!P`S``<`,P`'``````!+````70```!8%```Q!0``+@.H```<`! 0`'``4`!P``
M````0 8``$,&```N"@.``!P`$``<``0!!,_5W^&^6F_\/_P__#_\/_P__#_\/
M_P__#Q ``0```````0```````````````````````Q@.```^$T (1A)C^%<8%
M``'0`@.9>A- "8(28_F\H``(````I``$```````$`````````````````` ```
M`! 8```/A* %$828_A7&!0`!H 4&7H2@.!6"$F/Y/2@.``4$H``%%*``!>2@.``
M`@.`!`"D``0````*"`0``````````````````````"A@.```^$< @.1A$S_%<8%
M``%P" 9>A' (8(1,_X=H`````(A(```"``(`+@.`!`````( !````````````
M```````````*& ``#X1 "Q&$F/X5Q@.4``4 +!EZ$0 M@.A)C^AV@.`````B$@.`
M``(``P`N``$````$@. $```````````````````````H8```/A! .$828_A7&
M!0`!$ X&7H00#F"$F/Z': ````"(2 ```@.`$`"X``0````*"`0``````````
M````````````"A@.```^$X! 1A$S_%<8%``'@.$ 9>A. 08(1,_X=H`````(A(
M```"``4`+@.`!`````( !```````````````````````*& ``#X2P$Q&$F/X5
MQ@.4``; 3!EZ$L!-@.A)C^AV@.`````B$@.```(`!@.`N``$````$@. $`````````
M``````````````H8```/A( 6$828_A7&!0`!@.!8&7H2 %F"$F/Z': ````"(
M2 ```@.`'`"X``0````*"`0``````````````````````"A@.```^$ 4!D1A$S_
M%<8%``%0&09>A% 98(1,_X=H`````(A(```"``@.`+@.`!````03/U=P``````
M`````````/_______P$``````/__`0```!(`$0`)"#I<NOT;``D(#P`)"!D`
M"0@.;``D(#P`)"!D`"0@.;``D(&0!V+MH!YS)S"0(``````'![9 7>2HH3`@.``
M````YS)S"0H0#%0!````! `$``X!``#>2HH3W7I&4P$````$``0`#@.$``$@.J
MJ!1D>!TP`@.``````Q'7G%4@.JJ!0#```````"?%H7````````` ````0(``@.`%
M6)D@.+@.)R90$``````)]0KB$````````````!`@.`"`&1X'3!5'J P`0````0`
M! `.`0``51Z@.,)]0KB$!``````"V,'<R-F?_1@.(``````$ 7;#9P>V0%`P``
M````#S%4/[8P=S(#``````#/<() <2L;: $``````#9G_T8%6)D@.`0````0`
M! `.`0``W7I&4P)\6A<!```````*$ Q4!RLG6 $``````"E"0E?/<() `0``
M``0`! `.`0``!RLG6 ````````````$"``(`XTAQ7RE"0E<"``````!^0O9B
M=B[:`0,``````"X"<F4````````````!`@.`"`'$K&V@.`````` ``````!`@.`"
M`)1N.'_C2'%?`P``````7 ````0````(````Y0````````!;````[@.`"`'IU
M"@."7'0T`$500`.-*$0"9&!8`,3 9`$Q_' "49B(`@. <L`$%Z+ `Q!RT`1RTN
M`$@.#,0#0&C(`3%XS`(1>,P#.&CH`$A$[`+L'/@.#O0S\`9#%!`(IS00!?,4D`
M,$5*`*5#30`X/TX`V!E/`%PQ4@.`&<58`)7E7`+HP7 "1*EX`>B-@.`&)+8P#:
M&V4`Z@.YH`"LZ: "^,&X`,@.]P`$\1<0!!%G(`^P5U`/)B@.0`K<80`;4B&`$QN
MA@.`%18<`53"*`#(<C !V'Y(`0T>=`%\FHP!7>*,`QSZE`*HEI@.!C<*8`7B^I
M`)LWJ0!(4JD`\5:I`"\%J@.`0':L`4U:K`*EVL@.#O%[4`$SV[` $D#O #Y+;P`
MZQV^`/U"P !B(L(`C@.+)`+Q&RP#I"<\`SGK0``P]U !8--4`7PG6`-1ZUP`1
M+]D`DVW9`.-UV0#7']T`[4+?`(M^X0`;$>8`7!?G`,8W\@.!7(OD`"P_Z`%Y]
M_@.#_0 . `0!$!@.``1 8``+ VZ (!``$`1 8```````!$!@.````````(0````
M`````"P*``! ```0`$ ``/__`0````<`50!N`&L`;@.!O`'<`;@.#__P$`" ``
M````````````__\!``````#__P```@.#__P````#__P```@.#__ P`````$````
M1Q:0`0```@.(&`P4$!0(#!(=Z`" ```" " ````````#_`0```````%0`:0!M
M`&4`<P`@.`$X`90!W`" `4@.!O`&T`80!N````-1:0`0(`!04!`@.$'!@.(%!P``
M```````0``````````````" `````%,`>0!M`&(`;P!L````,R:0`0```@.L&
M! ("`@.("!(=Z`" ```" " ````````#_`0```````$$`<@.!I`&$`; ```#<F
MD $```(+!@.0#!00$`@.2'`@.`@.````````````````GP$```````!6 `&4`<@.!D
M`&$`;@.!A````(@.`$`'$(B!@.`\- "Y 1H`0````#FF96&G>&:I@.`````&`!T`
M``"$`0``J @.```$`!0````0``Q 2````A $``*@.(```!``4````2````````
M`"$#`/ 0`````0``````````````````````````````````````````` ```
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````@.'H 6T`+0`@.8$R- ``$ `9`&0````9````)PH``"<*````````````
M````````````````````````````````````````````````` ```````````
M```````````"`````````````3*#40#P$ `(````````````````````````
M``````````````!(6 `````H\/\/`0`!/P``Y 0``/___W____]_____?___
M_W____]_____?____W^[!SX``````#(``````````````````````/__$@.``
M``````````````````D`3@.!I`&L`2@.!O`&$`;@.!N`&4`"0!.` &D`:P!*`&\`
M80!N`&X`90```````````````````````````! ````&`````0``````# ``
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````#^_P``!0$"```````````````````````!````X(6?\ OE/:!"KD0@.`
M*R>SV3 ```!@.`0``$ ````$```"(`````@.```) ````#````G ````0```"H
M````!0```+P````'````R ````@.```#<````"0```/ ````2````_ ````H`
M```<`0``# ```"@.!```-````- $```X```! `0``#P```$@.!```0````4 $`
M`!,```!8`0```@.```.0$```>````! `````````>````! `````````>````
M# ```$YI:TIO86YN90```!X````$`````````!X````,````3F]R;6%L+F1O
M= ``'@.````P```!.:6M*;V%N;F4````>````! ```#8````>````& ```$UI
M8W)O<V]F="!/9F9I8V4@.5V]R9 ```$ `````[AX-! ```$ `````U+I,/5S%
M`4 `````=@.2 @.-O%`0,````!`````P```(0!```#````J @.```,`````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````_O\```4!`@.```````````````````````@.````+5S =6<+AL0DY<(
M`"LL^:Y$````!=7-U9PN&Q"3EP@.`*RSYKBP!``#H````# ````$```!H````
M#P```' ````%````? ````8```"$````$0```(P````7````E ````L```"<
M````$ ```*0````3````K ```!8```"T````#0```+P````,````R0````(`
M``#D! ``'@.````0``````````P```!(````#````!0````,````G"@.`` `P``
M`-@.8"P`+``````````L`````````"P`````````+`````````!X0 ```!````
M`0`````,$ ```@.```!X````&````5&ET;&4``P````$`````U 0```,`````
M````( ````$````X`````@.```$ ````!`````@.````P```!?4$E$7TA,24Y+
M4P`"````Y 0``$$```",! ``) ````,```!F`'P``P````\````#````````
M``,````%````'P```"<```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!C`',`
M90`N`&T`<P`O`&T`90!S`',`80!G`&4`,0`W`#4`.0`V`#8`- `N`&@.`= !M
M`&P``````!\````!```````3! ,```!%`$H``P````P````#``````````,`
M```%````'P```$H```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O
M`',`;P!F`'0`+@.!C`&\`;0`O`'0`90!C`&@.`;@.!E`'0`+P!P` '(`;P!D`'0`
M90!C`&@.`;@.!O`&P`+P!S`'$`; `O`#(`, `P`# `+P!D`&4`< !L`&\`>0`O
M`&@.`80!S`&\`9P`P`#$`+@.!M`',`< !X````'P````$``````!,$`P```$L`
M5@.`#````"0````,``````````P````4````?````30```&@.`= !T`' `.@.`O
M`"\`=P!W`'<`+@.!M`&D`8P!R`&\`<P!O`&8`= `N`&,`;P!M`"\`= !E`&,`
M: !N`&4`= `O`' `<@.!O`&0`= !E`&,`: !N`&\`; `O`',`<0!L`"\`,@.`P
M`# `, `O`&T`80!I`&X`= !A`&D`;@.`O`&8`80!I`&P`8P!L`'4`<P`N`&T`
M<P!P`'@.``````!\````!```````3! ,````)`$P``P````8````#````````
M``,````%````'P```"H```!H`'0`= !P`#H`+P`O`',`=0!P`' `;P!R`'0`
M+@.!M`&D`8P!R`&\`<P!O`&8`= `N`&,`;P!M`"\`/P!K`&(`:0!D`#T`,P`P
M`#$`-@.`P`# ````?`````0``````$P0#````< `2``,````#`````P``````
M```#````!0```!\```!0````: !T`'0`< `Z`"\`+P!W`'<`=P`N`',`<0!L
M`"T`<P!E`'(`=@.!E`'(`+0!P`&4`<@.!F`&\`<@.!M`&$`;@.!C` &4`+@.!C`&\`
M;0`O`',`<0!L`',`90!R`'8`90!R`#(`, `P`# `7P!C`&P`=0!S`'0`90!R
M`&D`;@.!G`%\`:0!N`',`= !A`&P`; !?`&T`80!I`&X`+@.!A`',`< ```!\`
M```!```````3! ,``````%\``P`````````#``````````,````%````'P``
M`&T```!H`'0`= !P`#H`+P`O`'<`=P!W`"X`;0!I`&,`<@.!O`',`;P!F`'0`
M+@.!C`&\`;0`O`&0`;P!W`&X`; !O`&$`9 !S`"\`9 !E`'0`80!I`&P`<P`N
M`&$`<P!P`'@.`/P!&`&$`;0!I`&P`>0!)`$0`/0`Y`#8`9@.`W`#8`90!D`#<`
M+0`Y`#8`,P`T`"T`- `S`# `, `M`#D`,0`U`#D`+0`X`#D`-@.`S`#@.`9@.`T
M`&(`- !E`&8`-P`F`&0`:0!S`' `; !A`'D`; !A`&X`9P`]`&4`;@.``````
M'P````$``````!,$````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M``````````$````"`````P````0````%````!@.````<````(` ```"0````H`
M```+````# ````T````.````#P```! ```#^____$@.```!,````4````%0``
M`!8````7````& ```/[___\:````&P```!P````=````'@.```!\````@.````
M(0```"(````C````) ```"4````F````_O___R@.````I````*@.```"L````L
M````+0```"X```#^____, ```#$````R````,P```#0````U````-@.```/[_
M___]____.0```/[____^_____O__________________________________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M________________________________4@.!O`&\`= `@.`$4`;@.!T`'(`>0``
M````````````````````````````````````````````````` ````````!8`
M!0'__________P,````&"0(``````, ```````!&````````````````P*N\
MFH#;Q0$[````@. ````````!$`&$`= !A````````````````````````````
M````````````````````````````````````````````````" @.`"`?______
M_________P``````````````````````````````````````` ````````!$`
M````$ ```````#$`5 !A`&(`; !E````````````````````````````````
M```````````````````````````````````````.``(!`0``` `8```#_____
M````````````````````````````````````````````````& 0```&4:````
M````5P!O`'(`9 !$`&\`8P!U`&T`90!N`'0`````````````````````````
M`````````````````````````````!H``@.$"````!0```/____\`````````
M````````````````````````````````````````````+B ````````%`%,`
M=0!M`&T`80!R`'D`20!N`&8`;P!R`&T`80!T`&D`;P!N````` ```````````
M````````````````````* `"`?_______________P``````````````````
M`````````````````````````````"<`````$ ````````4`1 !O`&,`=0!M
M`&4`;@.!T`%,`=0!M`&T`80!R`'D`20!N`&8`;P!R`&T`80!T` &D`;P!N````
M```````````X``(!! ```/__________````````````````````````````
M````````````````````+P`````0`````````0!#`&\`;0!P` $\`8@.!J````
M````````````````````````````````````````````````` ```````````
M`!(``@.#_______________\`````````````````````````` ```````````
M````````````````<0``````````````````````````````` ```````````
M````````````````````````````````````````````````` ````````/__
M_____________P``````````````````````````````````` ```````````
M``````````````````$```#^_________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M_________________________________________________ ___________
M________________________________________`0#^_P,*` `#_____!@.D"
M``````# ````````1A\```!-:6-R;W-O9G0@.3V9F:6-E(%=O<F0@.1&]C=6UE
M;G0`"@.```$U35V]R9$1O8P`0````5V]R9"Y$;V-U;65N="XX`/0YLG$`````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
M````````````````````````````````````````````````` ```````````
"````
`
end
|||Hello Nick,
I think you forgot to post the links..?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> These are my notes with links at the end.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:C8CEA952-209A-41BF-8C85-F4473964CE62@.microsoft.com...
>
>
|||They are the blue hyperlinks in the word document I attached (last page).
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:D4C201FF-5E36-42B0-9FF2-C319E11CC07A@.microsoft.com...[vbcol=seagreen]
> Hello Nick,
> I think you forgot to post the links..?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
|||Nik,
I am sorry if I have used the wrong terms when asking the question.
I am very well acquainted with the MS Cluster Services but I am no expert on
SQL, I admit that, even if I have clustered a few by now.
In an SQL 2000 clusterinstallation, the logs will default reside on the same
shared drive as the db:s. Oracle (of which I also have done several succesful
cluster installations) recommend to put the log files on one or several local
disks, of security and performance reasons.
So, I ask you the question again:
Does Microsoft recommend the same ?
Directing the logfiles on local disks and separate from the O.S. ?
Or maybe on another shared drive than the DB:s ?
If the latter one is suggested, what is the impact on the "SQL function" if
the group with the logfiles would suddenly change ownership ?
I cannot find any documentation or MS recommendations on where to put these
logfiles.
Could you please clarify this, Nik and enlighten me ?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> Failover does not occur for disks just the computer itself. You have a
> shared disk resource(s) which 1 node in the cluster owns. Should that node
> fail then another will take over ownership of the disk resources. It sounds
> like you require fault tolerant hardware. I siggest to re-read all the links
> so you better understand clustering and what it provides.
> And log file placement is usually decided by performance resons.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:1B59D480-E4F9-40F1-8609-CD7CC07DC331@.microsoft.com...
>
>
|||Putting logfiles on seperate drives is a performance issue. RAID-5 is
striped with paraity so it effectively spreads the IO over several physical
drives anyway. If you do not have performance issues then placing the drives
on the same shared drive as the data files is fine. You cannot put the
logfiles on local drives they must reside on a shared drive so the
opwnership can change. There are no issues with change of ownership. If node
1 fails then SQL is shutdown on that node the disks change ownership to the
other node and SQL starts on that node owning the same data that was being
used on the first node.
I hope this clarifies things for you.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:A2DE7B47-17C2-4BF8-81E4-14CF9D4273ED@.microsoft.com...[vbcol=seagreen]
> Nik,
> I am sorry if I have used the wrong terms when asking the question.
> I am very well acquainted with the MS Cluster Services but I am no expert
> on
> SQL, I admit that, even if I have clustered a few by now.
> In an SQL 2000 clusterinstallation, the logs will default reside on the
> same
> shared drive as the db:s. Oracle (of which I also have done several
> succesful
> cluster installations) recommend to put the log files on one or several
> local
> disks, of security and performance reasons.
> So, I ask you the question again:
> Does Microsoft recommend the same ?
> Directing the logfiles on local disks and separate from the O.S. ?
> Or maybe on another shared drive than the DB:s ?
> If the latter one is suggested, what is the impact on the "SQL function"
> if
> the group with the logfiles would suddenly change ownership ?
> I cannot find any documentation or MS recommendations on where to put
> these
> logfiles.
> Could you please clarify this, Nik and enlighten me ?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
|||Nik,
Actually, not quite.
One of the main reasons to put the logfiles on local disks in an Oracle
cluster environment is
that if the shared disk with the db:s totally fails, I am able to recover
the db:s anyway from the logfiles.
According to your statement, I am not able use local drives to put the SQL
logfiles.
To put them in another cluster group and consequently on another drive would
then not be possible either since the node that owns the SQL-db:s HAS to be
able to write to the disk with the logfiles. And if the shared disk with the
logfiles is owned by the other node...
You see what I mean here ?
My conclusion of our discussion is that I HAVE to place the logfiles on the
same shared disk as the SQL-db:s .
Do you agree, Nik ?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> Putting logfiles on seperate drives is a performance issue. RAID-5 is
> striped with paraity so it effectively spreads the IO over several physical
> drives anyway. If you do not have performance issues then placing the drives
> on the same shared drive as the data files is fine. You cannot put the
> logfiles on local drives they must reside on a shared drive so the
> opwnership can change. There are no issues with change of ownership. If node
> 1 fails then SQL is shutdown on that node the disks change ownership to the
> other node and SQL starts on that node owning the same data that was being
> used on the first node.
> I hope this clarifies things for you.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:A2DE7B47-17C2-4BF8-81E4-14CF9D4273ED@.microsoft.com...
>
>
|||I see what you're driving at but you CAN have 2 seperate disk groups and set
the dependancies accordingy such that if one group changes then so must the
other group.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:F39B4B53-BE89-4AF0-836C-8846CAA9AE93@.microsoft.com...[vbcol=seagreen]
> Nik,
> Actually, not quite.
> One of the main reasons to put the logfiles on local disks in an Oracle
> cluster environment is
> that if the shared disk with the db:s totally fails, I am able to recover
> the db:s anyway from the logfiles.
> According to your statement, I am not able use local drives to put the SQL
> logfiles.
> To put them in another cluster group and consequently on another drive
> would
> then not be possible either since the node that owns the SQL-db:s HAS to
> be
> able to write to the disk with the logfiles. And if the shared disk with
> the
> logfiles is owned by the other node...
> You see what I mean here ?
> My conclusion of our discussion is that I HAVE to place the logfiles on
> the
> same shared disk as the SQL-db:s .
> Do you agree, Nik ?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
|||Are you sure ?
I have never seen any documents describing dependencies BETWEEN groups.
Only WITHIN groups.
If this is possible, why is it so poorly documented ?
You don′t happen to have any ?
Regards
Johnny Lundgren
"Nik Marshall-Blank" wrote:
> I see what you're driving at but you CAN have 2 seperate disk groups and set
> the dependancies accordingy such that if one group changes then so must the
> other group.
> --
> Nik Marshall-Blank MCSD/MCDBA
> Linz, Austria
> "Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
> message news:F39B4B53-BE89-4AF0-836C-8846CAA9AE93@.microsoft.com...
>
>
|||Oops Sunday rest day head got me there.
You are right, I meant resources, You can create another disk resource for
the logfiles within the same group and make the logfile resource dependacies
suc that they will always swap ownership with the main db resource group. I
can't see why you'd want a seperate group for the logfiles though, another
logfile resource within the same group would be sufficient.
I've re-read your posts to try to make sure I undertand your requirements
and I think I've done that. If you think I've misunderstood or not explaied
cleary enough please post it.
Nik Marshall-Blank MCSD/MCDBA
Linz, Austria
"Johnny Lundgren" <JohnnyLundgren@.discussions.microsoft.com> wrote in
message news:FB5EFBD5-07FA-4BF4-B537-631244748912@.microsoft.com...[vbcol=seagreen]
> Are you sure ?
> I have never seen any documents describing dependencies BETWEEN groups.
> Only WITHIN groups.
> If this is possible, why is it so poorly documented ?
> You dont happen to have any ?
> Regards
> Johnny Lundgren
> "Nik Marshall-Blank" wrote:
restoring old mdf file
I need to restore a Sql2000 database from an .mdf file from last July. Can
people tell me if the following procedure is correct, or am I missing
something? :
1. restore the .mdf file from backup to temp location (done)
2. backup existing database (in case I need to restore this one)
3. delete existing database (to cleanup metadata in master)
4. shutdown sqlserver
5. replace existing .mdf file with old one
6. startup sqlserver
7. attach database to .mdf -- how do I do this?
Thanks for any assistance with this.
-Frank Brown
Seattle Fire Dept
http://www.inwa.net/~frog/take a look at the sp_attach_db procedure, in BOL.
Alex Ivascu
"frank brown" <someone@.somewhere.net> wrote in message
news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> I need to restore a Sql2000 database from an .mdf file from last July.
Can
> people tell me if the following procedure is correct, or am I missing
> something? :
> 1. restore the .mdf file from backup to temp location (done)
> 2. backup existing database (in case I need to restore this one)
> 3. delete existing database (to cleanup metadata in master)
> 4. shutdown sqlserver
> 5. replace existing .mdf file with old one
> 6. startup sqlserver
> 7. attach database to .mdf -- how do I do this?
> Thanks for any assistance with this.
> -Frank Brown
> Seattle Fire Dept
> http://www.inwa.net/~frog/
>|||Hi ,
This activity do not require a SQL server shutdown. Please use the below
commands to perform:
1. drop database databasename
2. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any directory)
3. EXEC sp_attach_db @.dbname = N'DBNAME',
@.filename1 = N'c:\mssql\data\dbname.mdf',
@.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
Now your old database will be ready to use.
Incase if you need the old and new database in server then u have to use
Move option along with
sp_attach_db command.
Thanks
Hari
MCDBA
"alex ivascu" <alexdivascu@.sbcglobalNO.SPAMnet> wrote in message
news:q6Ulb.5679$sP6.5569@.newssvr27.news.prodigy.com...
> take a look at the sp_attach_db procedure, in BOL.
> Alex Ivascu
>
> "frank brown" <someone@.somewhere.net> wrote in message
> news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> > I need to restore a Sql2000 database from an .mdf file from last July.
> Can
> > people tell me if the following procedure is correct, or am I missing
> > something? :
> >
> > 1. restore the .mdf file from backup to temp location (done)
> > 2. backup existing database (in case I need to restore this one)
> > 3. delete existing database (to cleanup metadata in master)
> > 4. shutdown sqlserver
> > 5. replace existing .mdf file with old one
> > 6. startup sqlserver
> > 7. attach database to .mdf -- how do I do this?
> >
> > Thanks for any assistance with this.
> >
> > -Frank Brown
> > Seattle Fire Dept
> > http://www.inwa.net/~frog/
> >
> >
>|||Huh? If you drop the database, there are no more database file...
Also, sp_attach_db is only guaranteed to work if you first detach the database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eLPaYodmDHA.1072@.TK2MSFTNGP09.phx.gbl...
> Hi ,
> This activity do not require a SQL server shutdown. Please use the below
> commands to perform:
> 1. drop database databasename
> 2. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any directory)
> 3. EXEC sp_attach_db @.dbname = N'DBNAME',
> @.filename1 = N'c:\mssql\data\dbname.mdf',
> @.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
> Now your old database will be ready to use.
> Incase if you need the old and new database in server then u have to use
> Move option along with
> sp_attach_db command.
> Thanks
> Hari
> MCDBA
>
>
>
>
> "alex ivascu" <alexdivascu@.sbcglobalNO.SPAMnet> wrote in message
> news:q6Ulb.5679$sP6.5569@.newssvr27.news.prodigy.com...
> > take a look at the sp_attach_db procedure, in BOL.
> >
> > Alex Ivascu
> >
> >
> > "frank brown" <someone@.somewhere.net> wrote in message
> > news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> > > I need to restore a Sql2000 database from an .mdf file from last July.
> > Can
> > > people tell me if the following procedure is correct, or am I missing
> > > something? :
> > >
> > > 1. restore the .mdf file from backup to temp location (done)
> > > 2. backup existing database (in case I need to restore this one)
> > > 3. delete existing database (to cleanup metadata in master)
> > > 4. shutdown sqlserver
> > > 5. replace existing .mdf file with old one
> > > 6. startup sqlserver
> > > 7. attach database to .mdf -- how do I do this?
> > >
> > > Thanks for any assistance with this.
> > >
> > > -Frank Brown
> > > Seattle Fire Dept
> > > http://www.inwa.net/~frog/
> > >
> > >
> >
> >
>|||Hi,
Frank's mail says that he need to drop the existing database and load the
old database. That is the reason I mentioned the "drop database" command
initially.
I do agree with you , some times the SP_attachdb wont work incase if we are
not using SP_detachdb.
Frank,
What you can do is perform the below steps to put you in safer
side.
1. Perform a backup of your existing database and keep it in a safe folder.
2. drop database databasename
3. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any directory)
4. EXEC sp_attach_db @.dbname = N'DBNAME',
@.filename1 = N'c:\mssql\data\dbname.mdf',
@.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
Thanks
Hari
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:e0RKXhfmDHA.1244@.TK2MSFTNGP11.phx.gbl...
> Huh? If you drop the database, there are no more database file...
> Also, sp_attach_db is only guaranteed to work if you first detach the
database.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eLPaYodmDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > Hi ,
> >
> > This activity do not require a SQL server shutdown. Please use the below
> > commands to perform:
> >
> > 1. drop database databasename
> > 2. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any
directory)
> > 3. EXEC sp_attach_db @.dbname = N'DBNAME',
> > @.filename1 = N'c:\mssql\data\dbname.mdf',
> > @.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
> >
> > Now your old database will be ready to use.
> >
> > Incase if you need the old and new database in server then u have to use
> > Move option along with
> > sp_attach_db command.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "alex ivascu" <alexdivascu@.sbcglobalNO.SPAMnet> wrote in message
> > news:q6Ulb.5679$sP6.5569@.newssvr27.news.prodigy.com...
> > > take a look at the sp_attach_db procedure, in BOL.
> > >
> > > Alex Ivascu
> > >
> > >
> > > "frank brown" <someone@.somewhere.net> wrote in message
> > > news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> > > > I need to restore a Sql2000 database from an .mdf file from last
July.
> > > Can
> > > > people tell me if the following procedure is correct, or am I
missing
> > > > something? :
> > > >
> > > > 1. restore the .mdf file from backup to temp location (done)
> > > > 2. backup existing database (in case I need to restore this one)
> > > > 3. delete existing database (to cleanup metadata in master)
> > > > 4. shutdown sqlserver
> > > > 5. replace existing .mdf file with old one
> > > > 6. startup sqlserver
> > > > 7. attach database to .mdf -- how do I do this?
> > > >
> > > > Thanks for any assistance with this.
> > > >
> > > > -Frank Brown
> > > > Seattle Fire Dept
> > > > http://www.inwa.net/~frog/
> > > >
> > > >
> > >
> > >
> >
> >
>
people tell me if the following procedure is correct, or am I missing
something? :
1. restore the .mdf file from backup to temp location (done)
2. backup existing database (in case I need to restore this one)
3. delete existing database (to cleanup metadata in master)
4. shutdown sqlserver
5. replace existing .mdf file with old one
6. startup sqlserver
7. attach database to .mdf -- how do I do this?
Thanks for any assistance with this.
-Frank Brown
Seattle Fire Dept
http://www.inwa.net/~frog/take a look at the sp_attach_db procedure, in BOL.
Alex Ivascu
"frank brown" <someone@.somewhere.net> wrote in message
news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> I need to restore a Sql2000 database from an .mdf file from last July.
Can
> people tell me if the following procedure is correct, or am I missing
> something? :
> 1. restore the .mdf file from backup to temp location (done)
> 2. backup existing database (in case I need to restore this one)
> 3. delete existing database (to cleanup metadata in master)
> 4. shutdown sqlserver
> 5. replace existing .mdf file with old one
> 6. startup sqlserver
> 7. attach database to .mdf -- how do I do this?
> Thanks for any assistance with this.
> -Frank Brown
> Seattle Fire Dept
> http://www.inwa.net/~frog/
>|||Hi ,
This activity do not require a SQL server shutdown. Please use the below
commands to perform:
1. drop database databasename
2. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any directory)
3. EXEC sp_attach_db @.dbname = N'DBNAME',
@.filename1 = N'c:\mssql\data\dbname.mdf',
@.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
Now your old database will be ready to use.
Incase if you need the old and new database in server then u have to use
Move option along with
sp_attach_db command.
Thanks
Hari
MCDBA
"alex ivascu" <alexdivascu@.sbcglobalNO.SPAMnet> wrote in message
news:q6Ulb.5679$sP6.5569@.newssvr27.news.prodigy.com...
> take a look at the sp_attach_db procedure, in BOL.
> Alex Ivascu
>
> "frank brown" <someone@.somewhere.net> wrote in message
> news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> > I need to restore a Sql2000 database from an .mdf file from last July.
> Can
> > people tell me if the following procedure is correct, or am I missing
> > something? :
> >
> > 1. restore the .mdf file from backup to temp location (done)
> > 2. backup existing database (in case I need to restore this one)
> > 3. delete existing database (to cleanup metadata in master)
> > 4. shutdown sqlserver
> > 5. replace existing .mdf file with old one
> > 6. startup sqlserver
> > 7. attach database to .mdf -- how do I do this?
> >
> > Thanks for any assistance with this.
> >
> > -Frank Brown
> > Seattle Fire Dept
> > http://www.inwa.net/~frog/
> >
> >
>|||Huh? If you drop the database, there are no more database file...
Also, sp_attach_db is only guaranteed to work if you first detach the database.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eLPaYodmDHA.1072@.TK2MSFTNGP09.phx.gbl...
> Hi ,
> This activity do not require a SQL server shutdown. Please use the below
> commands to perform:
> 1. drop database databasename
> 2. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any directory)
> 3. EXEC sp_attach_db @.dbname = N'DBNAME',
> @.filename1 = N'c:\mssql\data\dbname.mdf',
> @.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
> Now your old database will be ready to use.
> Incase if you need the old and new database in server then u have to use
> Move option along with
> sp_attach_db command.
> Thanks
> Hari
> MCDBA
>
>
>
>
> "alex ivascu" <alexdivascu@.sbcglobalNO.SPAMnet> wrote in message
> news:q6Ulb.5679$sP6.5569@.newssvr27.news.prodigy.com...
> > take a look at the sp_attach_db procedure, in BOL.
> >
> > Alex Ivascu
> >
> >
> > "frank brown" <someone@.somewhere.net> wrote in message
> > news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> > > I need to restore a Sql2000 database from an .mdf file from last July.
> > Can
> > > people tell me if the following procedure is correct, or am I missing
> > > something? :
> > >
> > > 1. restore the .mdf file from backup to temp location (done)
> > > 2. backup existing database (in case I need to restore this one)
> > > 3. delete existing database (to cleanup metadata in master)
> > > 4. shutdown sqlserver
> > > 5. replace existing .mdf file with old one
> > > 6. startup sqlserver
> > > 7. attach database to .mdf -- how do I do this?
> > >
> > > Thanks for any assistance with this.
> > >
> > > -Frank Brown
> > > Seattle Fire Dept
> > > http://www.inwa.net/~frog/
> > >
> > >
> >
> >
>|||Hi,
Frank's mail says that he need to drop the existing database and load the
old database. That is the reason I mentioned the "drop database" command
initially.
I do agree with you , some times the SP_attachdb wont work incase if we are
not using SP_detachdb.
Frank,
What you can do is perform the below steps to put you in safer
side.
1. Perform a backup of your existing database and keep it in a safe folder.
2. drop database databasename
3. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any directory)
4. EXEC sp_attach_db @.dbname = N'DBNAME',
@.filename1 = N'c:\mssql\data\dbname.mdf',
@.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
Thanks
Hari
"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@.cornerstone.se>
wrote in message news:e0RKXhfmDHA.1244@.TK2MSFTNGP11.phx.gbl...
> Huh? If you drop the database, there are no more database file...
> Also, sp_attach_db is only guaranteed to work if you first detach the
database.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:eLPaYodmDHA.1072@.TK2MSFTNGP09.phx.gbl...
> > Hi ,
> >
> > This activity do not require a SQL server shutdown. Please use the below
> > commands to perform:
> >
> > 1. drop database databasename
> > 2. copy the .MDF and .LDF files to c:\mssql\data\ (Itcan be any
directory)
> > 3. EXEC sp_attach_db @.dbname = N'DBNAME',
> > @.filename1 = N'c:\mssql\data\dbname.mdf',
> > @.filename2 = N'c:\MSSQL\Data\dbname_log.ldf'
> >
> > Now your old database will be ready to use.
> >
> > Incase if you need the old and new database in server then u have to use
> > Move option along with
> > sp_attach_db command.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > "alex ivascu" <alexdivascu@.sbcglobalNO.SPAMnet> wrote in message
> > news:q6Ulb.5679$sP6.5569@.newssvr27.news.prodigy.com...
> > > take a look at the sp_attach_db procedure, in BOL.
> > >
> > > Alex Ivascu
> > >
> > >
> > > "frank brown" <someone@.somewhere.net> wrote in message
> > > news:LPTlb.18$Nd3.3944@.news-west.eli.net...
> > > > I need to restore a Sql2000 database from an .mdf file from last
July.
> > > Can
> > > > people tell me if the following procedure is correct, or am I
missing
> > > > something? :
> > > >
> > > > 1. restore the .mdf file from backup to temp location (done)
> > > > 2. backup existing database (in case I need to restore this one)
> > > > 3. delete existing database (to cleanup metadata in master)
> > > > 4. shutdown sqlserver
> > > > 5. replace existing .mdf file with old one
> > > > 6. startup sqlserver
> > > > 7. attach database to .mdf -- how do I do this?
> > > >
> > > > Thanks for any assistance with this.
> > > >
> > > > -Frank Brown
> > > > Seattle Fire Dept
> > > > http://www.inwa.net/~frog/
> > > >
> > > >
> > >
> > >
> >
> >
>
Monday, March 12, 2012
Restoring Master DB to a clustered server
Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond
Restoring Master DB to a clustered server
Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
Tedmond
Hello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
Tedmond
Hello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond
Restoring Master DB to a clustered server
Dear all,
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond
Can anyone tell me the procedure of restoring the master database to a
clustered server? Do I need to do the same thing in both active and standby
servers?
Thanks for any help.
TedmondHello,
Please try the steps in test environment and do in prod env:-
a. Identify which active cluster node SQL Server is currently running on,
such as node1.
b. From Cluster Administrator - windows program groups, take the SQL Server
resources off-line.
c. Go to the node running SQL Server (see step 1) and start it from the
command prompt using:
sqlservr.exe -c -m
d. Restore the Master database .
e. shutdown SQL Server from the command prompt.
f. Do the same step in passive sql server [Step c and d only ]
g. Using Cluster Administrator, restart the SQL Server resources.
Thanks
Hari
"Tedmond" <Tedmond@.discussions.microsoft.com> wrote in message
news:3F306584-7CD4-49DE-A535-900B0560B6AF@.microsoft.com...
> Dear all,
> Can anyone tell me the procedure of restoring the master database to a
> clustered server? Do I need to do the same thing in both active and
> standby
> servers?
> Thanks for any help.
> Tedmond
Wednesday, March 7, 2012
restoring from .bak
i have sql server 2005 dev installed on a laptop. i have 2 .bak's from production sql server 2005 database. i went through the gui restore procedure and both backup files completed successfully. now both databases are in the (Restoring...) status and have been for quite some time. i have sp2 applied. when will these become available? each .bak was around 400 mb. it has been a few hours.Did you refresh your GUI afterte restore? Can you connect to your database?|||it's now the morning and been at least a good 12 hours. refresh in the GUI shows them still in restoring status. i closed and reopened the management studio and they are still both restoring. i am unable to choose either database from the drop down when i open a new query window. i told it during restore to do them in norecovery mode under the expectation that this would be the fastest.|||i did notice that the data files created were substantially bigger... one backup created a 7.2gb mdf, 92mb ldf, the other created a 543mb mdf, 1.3gb ldf, and 371mb ndf... actually it appears when I specified the new filepath for that one from the backup, that I forgot the suffix. will that matter? I suppose I could stop the db service and rename it to an .ndf real quick. doesn't seem to be the cause of my slow restore issue though..|||FYI i restored the db in norecovery mode, under the impression that db access was denied only for the duration of the restore. i tried it with the first option later and the db's loaded fine. there must be some step to flip the db into available once in the restoring status, however it was not obvious/intuitive to me based on the gui or error messages i was receiving. but i seemed to be missing that step.|||I've experienced the same symptom, but with both norecovery and recovery options. Each time this produces a process that cannot be terminated until the machine is turned off. No errors are logged in sql server or windows. I've also verified the database backup through the verifyrestoreonly option and by restoring to another machine/instance.
Any thoughts?
|||i did not appear to have an active ongoing process; my cpu appeared idle. i didn't have a problem installing sp2 hoping it would fix the problem while the databases were in the restoring state. my assumption is there is some toggle (that should be made more apparent in gui error messages) that one could flip in there or some hidden sql to flip the db to go. i'm just naively jumping into this and figuring it out, my assumption is some book (a book online maybe) covers this situation (?) or perhaps it is some flakey bug.|||
That's your key.
Restoring a database in norecovery mode tells SQL Server that you intend to apply transaction log backups to roll the database forward before making it available. Thus the restore process is not complete. That's why your database is staying in 'restoring' state.
To bring your database online, simply use the command RESTORE DATABASE <dbname> WITH RECOVERY
You don't need a backup file for this - it just invokes the recovery logic to bring the DB online.
restoring from .bak
i have sql server 2005 dev installed on a laptop. i have 2 .bak's from production sql server 2005 database. i went through the gui restore procedure and both backup files completed successfully. now both databases are in the (Restoring...) status and have been for quite some time. i have sp2 applied. when will these become available? each .bak was around 400 mb. it has been a few hours.Did you refresh your GUI afterte restore? Can you connect to your database?|||it's now the morning and been at least a good 12 hours. refresh in the GUI shows them still in restoring status. i closed and reopened the management studio and they are still both restoring. i am unable to choose either database from the drop down when i open a new query window. i told it during restore to do them in norecovery mode under the expectation that this would be the fastest.|||i did notice that the data files created were substantially bigger... one backup created a 7.2gb mdf, 92mb ldf, the other created a 543mb mdf, 1.3gb ldf, and 371mb ndf... actually it appears when I specified the new filepath for that one from the backup, that I forgot the suffix. will that matter? I suppose I could stop the db service and rename it to an .ndf real quick. doesn't seem to be the cause of my slow restore issue though..|||FYI i restored the db in norecovery mode, under the impression that db access was denied only for the duration of the restore. i tried it with the first option later and the db's loaded fine. there must be some step to flip the db into available once in the restoring status, however it was not obvious/intuitive to me based on the gui or error messages i was receiving. but i seemed to be missing that step.|||I've experienced the same symptom, but with both norecovery and recovery options. Each time this produces a process that cannot be terminated until the machine is turned off. No errors are logged in sql server or windows. I've also verified the database backup through the verifyrestoreonly option and by restoring to another machine/instance.
Any thoughts?
|||i did not appear to have an active ongoing process; my cpu appeared idle. i didn't have a problem installing sp2 hoping it would fix the problem while the databases were in the restoring state. my assumption is there is some toggle (that should be made more apparent in gui error messages) that one could flip in there or some hidden sql to flip the db to go. i'm just naively jumping into this and figuring it out, my assumption is some book (a book online maybe) covers this situation (?) or perhaps it is some flakey bug.|||
That's your key.
Restoring a database in norecovery mode tells SQL Server that you intend to apply transaction log backups to roll the database forward before making it available. Thus the restore process is not complete. That's why your database is staying in 'restoring' state.
To bring your database online, simply use the command RESTORE DATABASE <dbname> WITH RECOVERY
You don't need a backup file for this - it just invokes the recovery logic to bring the DB online.
Subscribe to:
Posts (Atom)