Multiple mirrored databases

Suppose I have SERVER1 and SERVER2 with database DB1 and DB2 in both servers
with database mirroring enabled for both databases.

If I'm connected to Server1 and execute something like this: "SELECT * FROM
DB2..MyTable":

What if DB2 in Server1 is in not the Principal Parnet (i.e it is
synchonizing from Server2)?

Thanks.

If you are using SSMS to execute the query it will fail as the database that
is set has mirrored partner processes queries. If you need that you can
create a snapshot against the database and use it.

If you are using SQL Native Client and run the query against the database
with principel set to Server1. The SQL Native Client will realize Server1 is
not principle and goto Server2 to execute your query without you having to do
any additional work.

Hope this answers your question.

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"Jazmin Gutierrez" wrote:

> Suppose I have SERVER1 and SERVER2 with database DB1 and DB2 in both servers
> with database mirroring enabled for both databases.
>
> If I'm connected to Server1 and execute something like this: "SELECT * FROM
> DB2..MyTable":
>
> What if DB2 in Server1 is in not the Principal Parnet (i.e it is
> synchonizing from Server2)?
>
> Thanks.
>
>
>