Re: Using SQL Server Database mirroring between Primary and DR cluster

I am implementing such a configuration now, except that DR is a stand-alone server.

Use a DNS alias to abstract your Primary cluster. When you implement a mirror failover, change the DNS record to point to the alternate server.

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"xyberdobs" <xyberdobs@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:644BBE89-342B-498F-AD64-3A6A60EA02F4@xxxxxxxxxxxxxxxx
Hi all.

Any assistance regarding this would be greatly appreciated.

We have configured two sql server 2005 clustered environments - one will be
hosted at our local datacenter and the other at our DR site. These two
clusters are geographically dispersed.

The clusters will be configured as active/passive and I would like to
incorporate sql server 2005 database mirroring between the two clusters for
redundancy. Both clusters have the same domain names

My questions are:
can I configure both sql clustered instances to have the same sql virtual
server and instance name, so that in the event that the datacenter goes down,
we can initiate a manual failover between principal and mirror and the
front-end applications would still be able to connect using the same server
and instance name at the DR site?
If we cant have the same server and instance names, how can I configure the
cluster at DR site assume the identity of the primary virtual sql server and
instance name so that no code changes are required to point to the databases?

Many thanks.

.

Relevant Pages

  • RE: WSS install locked into MSDE DB - Can not install for SQL Serv
    ... For the MASTER database ... Althought we change the Configuration Application pool several times ... interface BUT they appear to be MSDE databases and not SQL Server databases. ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Using SQL Server Database mirroring between Primary and DR clu
    ... Much like mirroring, it is a database-level failover mechanism. ... This works just like mirroring does without the witness server. ... active/active cluster with virtual servers and physical servers on SQL Server ... >clusters are geographically dispersed. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using SQL Server Database mirroring between Primary and DR cluster
    ... This works just like mirroring does without the witness server. ... through DNS redirection so your virtual server Name in DNS will change its IP ... active/active cluster with virtual servers and physical servers on SQL Server ... The clusters will be configured as active/passive and I would like to ...
    (microsoft.public.sqlserver.clustering)
  • Re: Using SQL Server Database mirroring between Primary and DR clu
    ... This works just like mirroring does without the witness server. ... through DNS redirection so your virtual server Name in DNS will change its IP ... active/active cluster with virtual servers and physical servers on SQL Server ... The clusters will be configured as active/passive and I would like to ...
    (microsoft.public.sqlserver.clustering)
  • Re: Please advice
    ... Thanks alot but how about Porta Number because on the same Server SQL Server ... Configuration with 1433 port should I put the same 1433 Port Number for SQL ... Native Client Configuration" node and expand it. ...
    (microsoft.public.sqlserver.clients)