Hi All,
We are setting up standby database for MSSQL2008 in windows 2008 R2 environment. For our customer scenario, their infra team insist of using log shipping to transfer log file and file replication to to replication SAP files.
Therefore, i've a question in mind.. Do we need to maintain identical hostname for primary and standby database? fyi, they have cluster their primary and DR host.
If different hostname, virtual hostname is used, basically we can just drop the primary host from the domain and change that respective hostname, virutal hostname and ip for the DR host during swing over? If that's the case, is the any other action we need to perform? Do we need to change any registry? I believe SAP profiles and etc are identical due to the file replication.
If same hostname is maintained for both primary and standby host, i believe we might need to isolate standby host from the network and change the entries in DNS or routing table during swing over?
Any feedback and good suggestion are mostly welcome and much appreciate.
Cheers,
Regards
Nicholas Chang.
Edited by: Nicholas Chang on Feb 10, 2011 4:36 PM
Edited by: Nicholas Chang on Feb 10, 2011 4:37 PM