Guys,

I would appreciate if anyone help me out.

Let’s say we have DBServer1 & DBServer2 on Montreal and DBServer3 on Toronto.

DBServer1 & DBServer2 are on Data Center1
DBServer3 on Data Center2

From DBServer1 to DBServer2 I already created Database Mirroring and it’s
working fine, now I want to do replicate the data from DBServer2 (Mirrored
Server) to DBServer3 which is on Data Center2, what would be the best way and
all the internal people can also run all the reports against DBServer3.

Which one is best solution:

Database Mirroring and Replication OR Database Mirrroing and Log Shipping?

Thanks

Well I think of this type of question you will get a lot of different
answers and opinions. Here is a question I have... more clarifying than
anything... If you are mirroring from Server1 to Server2... and making the
assumption that the data you want to "replicate" from Server2 to Server3 is
the same data that you are replicating from Server1 to Server2. Then why
not setup Server3 as a mirrored instance and do reporting off of the
mirrored Server3.

So to recap... you would have either 1 of 2 solutions. Mirror Server1 to
Server2 and Server3 or Mirror Server1 to Server2 then I would log ship to
Server3. However, I have not tried... but see if you can mirror a mirrored
database (mirror server2 to server3). Just wanted to give you something
else to consider.

SQL Squirrel
http://www.lockergnome.com/sqlsquirrel/


"Rogers" <Rogers (AT) discussions (DOT) microsoft.com> wrote

You can have only one mirror server for Database Mirroring.

You can not enable Log Shipping on a mirror database because that database
would be inaccessible as it's going to be in recovery state.

--
Ekrem Önsoy


"SQL Squirrel" <brett.sqldba (AT) gmail (DOT) com>, iletisinde þunu yazdý,
news:O63Pf%239sJHA.4452 (AT) TK2MSFTNGP04 (DOT) phx.gbl...