Hello,
I would like to setup SQL 2005 database mirroring. Prior to this, I would
like to know if there are some technical prerequisites? For example, to do a
transactional replication, all tables need to have a primary key... Is there
the same kind of troubles with database mirroring?
How are handled the identity columns with mirroring when we make a recovery
after failure?
How are handled the triggers? Are they desactivated on the backup database?
Thanks a lot,
Eric.Mirroring doesn't work in the same way as replication. It is based on replicating the log records,
not re-generating the SQL statements from the log, like transaction replication does). Since *the
effect* of every modification is mirrored to the mirror database, it will be in the very same shape
as the principal database. (Well, if you go async, you could lose some committed transactions, but
that is a trade-off you have to think about.)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"itparis" <itparis@.discussions.microsoft.com> wrote in message
news:842CEE8B-29E4-4A38-BA9F-7881406C8E97@.microsoft.com...
> Hello,
> I would like to setup SQL 2005 database mirroring. Prior to this, I would
> like to know if there are some technical prerequisites? For example, to do a
> transactional replication, all tables need to have a primary key... Is there
> the same kind of troubles with database mirroring?
> How are handled the identity columns with mirroring when we make a recovery
> after failure?
> How are handled the triggers? Are they desactivated on the backup database?
> Thanks a lot,
> Eric.
No comments:
Post a Comment