"Keith Kratochvil" <sqlguy.bac***@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
>
>
>

"Tibor Karaszi" <tibor_please.no.email_kara***@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.bac***@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
>>
>>
>>
>

"Keith Kratochvil" <sqlguy.bac***@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_kara***@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.bac***@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
>>>
>>>
>>>
>>
>
>