This is a very informative document:
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
However, I would like to request one correction:
Step 4 under "Setup and Security" indicates that you have to specify the
partner and the witness. It tells you to to issue "ALTER DATABASE...SET
PARTNER..." on the intended principal first. Then you execute the same
command on the intended mirror.
Problem:
I could not get it to work that way. When I set up Mirroring in my
environment (9.0.2153) I had to execute the command on the mirror first then
against the primary.
--
Keith KratochvilHi Keith!
The early revisions of this document, I believe was based on a beta, so it is possible that the
behavior changed between that and production. Did you do a feedback at the bottom of that page?
(I see the same thing, btw, that you have to do mirror before principal...)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:u8enyNH9GHA.3820@.TK2MSFTNGP02.phx.gbl...
> This is a very informative document:
> http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
>
> However, I would like to request one correction:
> Step 4 under "Setup and Security" indicates that you have to specify the partner and the witness.
> It tells you to to issue "ALTER DATABASE...SET PARTNER..." on the intended principal first. Then
> you execute the same command on the intended mirror.
> Problem:
> I could not get it to work that way. When I set up Mirroring in my environment (9.0.2153) I had
> to execute the command on the mirror first then against the primary.
>
> --
> Keith Kratochvil
>
>|||argh. "Please limit comments to 256 characters"
I will try to be more to the point.
--
Keith Kratochvil
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:es8ewZH9GHA.3348@.TK2MSFTNGP03.phx.gbl...
> Hi Keith!
> The early revisions of this document, I believe was based on a beta, so it
> is possible that the behavior changed between that and production. Did you
> do a feedback at the bottom of that page?
> (I see the same thing, btw, that you have to do mirror before
> principal...)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
> news:u8enyNH9GHA.3820@.TK2MSFTNGP02.phx.gbl...
>> This is a very informative document:
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
>>
>> However, I would like to request one correction:
>> Step 4 under "Setup and Security" indicates that you have to specify the
>> partner and the witness. It tells you to to issue "ALTER DATABASE...SET
>> PARTNER..." on the intended principal first. Then you execute the same
>> command on the intended mirror.
>> Problem:
>> I could not get it to work that way. When I set up Mirroring in my
>> environment (9.0.2153) I had to execute the command on the mirror first
>> then against the primary.
>>
>> --
>> Keith Kratochvil
>>
>|||> argh. "Please limit comments to 256 characters"
Like a SQL 6.5 varchar?
;-)
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
news:OxGJasH9GHA.788@.TK2MSFTNGP05.phx.gbl...
> argh. "Please limit comments to 256 characters"
> I will try to be more to the point.
> --
> Keith Kratochvil
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:es8ewZH9GHA.3348@.TK2MSFTNGP03.phx.gbl...
>> Hi Keith!
>> The early revisions of this document, I believe was based on a beta, so
>> it is possible that the behavior changed between that and production. Did
>> you do a feedback at the bottom of that page?
>> (I see the same thing, btw, that you have to do mirror before
>> principal...)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Keith Kratochvil" <sqlguy.back2u@.comcast.net> wrote in message
>> news:u8enyNH9GHA.3820@.TK2MSFTNGP02.phx.gbl...
>> This is a very informative document:
>> http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
>>
>> However, I would like to request one correction:
>> Step 4 under "Setup and Security" indicates that you have to specify the
>> partner and the witness. It tells you to to issue "ALTER DATABASE...SET
>> PARTNER..." on the intended principal first. Then you execute the same
>> command on the intended mirror.
>> Problem:
>> I could not get it to work that way. When I set up Mirroring in my
>> environment (9.0.2153) I had to execute the command on the mirror first
>> then against the primary.
>>
>> --
>> Keith Kratochvil
>>
>>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment