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

As far as I know it says it preserves write ordering. But there is no way of
really validating that (not just for this product but all such products). You
can test as much as you want, and there is still no guarantee.

if we are indeed talking about the same product, on the DR server the SQL
service must be kept offline for the database files to be replicated by the
product.

I'm curious how it works out for others as a SQL Server DR tool.

Linchi

"Geoff N. Hiten" wrote:

The way it works with SQL is it has to make sure data and log blocks are
sent in order. You install sql to the target system and it does some attach
magic. It had problems with system databases, at least when I ran it.

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





"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:46D3E494-BA61-4578-8DEE-FFBFA2A5B051@xxxxxxxxxxxxxxxx
If it's what I have had experience with, it is a file system level tool
and
can replicate any database files. In fact, I don't think it cares what
database it's replicating. You specify what NTFS folders to replicate, and
have some options to exclude folders/files.

Linchi

"Geoff N. Hiten" wrote:

I have used it as well. It doesn't replicate system databases such as
msdb
or distribution. You can see where that can cause problems.

Much like mirroring, it is a database-level failover mechanism.

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





"Linchi Shea" <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:98C7A096-4963-4208-9F70-0904A0F009EE@xxxxxxxxxxxxxxxx
Have you tried it under a real disaster scenario rather than a planned
one?
Does it ever hang from time to time?

Linchi

"briantn54203" wrote:

I was faced with the same problem that you are having here. I have
been
demoing a software called CA XOsoft Replication and High Availability.

This works just like mirroring does without the witness server. It
works
through DNS redirection so your virtual server Name in DNS will change
its IP
Address so your SQL Instance will be up with the same name on either
side
of
your DR Plan.

This can be used for Exchange too, but that is for the Network guys. I
have
tested this thoroughly and it is a very solid product.

I have this running on my production side with a 5 instance, 5 node,
active/active cluster with virtual servers and physical servers on SQL
Server
2008 and Server 2008. I have it failing to my other DR site which is a
standalone box (could be clustered though) and it fails within a
minute.
You
can custom set your failover times to whatever you want.

The only thing that I do not like about the product is the drive
letters
and
locations have to match from one server to your DR server. This acts
just
like a microsoft cluster with the services stopping and starting on
one
side
or the other.

It is work checking out.
http://www.arcserve.com/products/product.aspx?id=8282

xyberdobs wrote:
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: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)