hi
SQLServer 2000 sp3 having master-target relationship. I want to change the
master server to another system.how can i replace this master server without
affecting target relations? any help , appreciated.BOL says:
Each target server reports to only one master server. You must defect a
target server from one master before you can enlist it into a different one.
"kpxus" <kpxus@.discussions.microsoft.com> wrote in message
news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
> hi
> SQLServer 2000 sp3 having master-target relationship. I want to change the
> master server to another system.how can i replace this master server
without
> affecting target relations? any help , appreciated.|||Instead of defect the target and re enlist, is there any way to restore
the master and msdb on other system and continue the msx-tsx relationship?
Quentin Ran wrote:
> BOL says:
> Each target server reports to only one master server. You must defect a
> target server from one master before you can enlist it into a different one.
> "kpxus" <kpxus@.discussions.microsoft.com> wrote in message
> news:36E6CC5D-5EA3-474D-927E-0E7A29FFABE0@.microsoft.com...
>>hi
>>SQLServer 2000 sp3 having master-target relationship. I want to change the
>>master server to another system.how can i replace this master server
> without
>>affecting target relations? any help , appreciated.
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment