Hello Fellow BizTalkers,
I have a complicated question related to getting servers back into
a BizTalk server group after being forcefully removed via the BizTalk
Admin Console - (had no choice - they were down).
We had some issues with W2K3 OS SP1 and the Daylight Savings Time
Hotfix, which caused a number of our servers not to function. With
them shut down, we needed to clean up the management database because
the Admin Console was taking wwaayyyy long to do anything, and was
killing our move process which uses the BizTalk WMI cl*****. The
BizTalk Group kept trying to contact the down servers behind the
scenes.
Knowing this, we opened the Admin Console and removed the
instances from the down machines and it warned us about windows
service cleanup and COM+ residual stuff that would need to be dealt
with. Now that we have the servers restored from backups and powered
up, we soon want to re-add them to the group. Since all the instances
were removed (from the BizTalkMgmtDB only - since the servers were not
running), now we have a number of servers with a number of host
instances still configured on them that are not reflected in the
BizTalkMgmtDB.
Looking closer at the BizTalkMgmtDB and its tables, stored procs
and how they work, etc, it looks like we may have an easy option to
restore these servers to actual use. The table dbo.adm_HostInstance
was trimmed down when we dropped (what we could of) these host
instances. Can we simply restore the contents of this table from a
recent database backup? We'd think of possibly setting
DisableHostInstance to -1 on any of the recovered data before
im****ting so that the instances won't get work routed to them until we
want them to.
Is this a valid option? or are we better off trying to clean up
whatever residual config was left on the servers and then re-install
the host instances. In the end, we just want the same host instances
to run on the same servers.
Any help / info / opinions appreciated!
- Curtis Herrick
|
