Re: Multiple Database Mirror Failover Question

On Sep 30, 6:52 pm, "yukon727" <yukon...@xxxxxxxxxxx> wrote:
Our organization has a medical application that is dependent on 6
independent SQL databases that are loaded on 1 SQL 2005 server/instance.
Can a "SQL 2005 High Availability Database Mirror" be used to mirror all
six databases and automatically failover.
If I have understood correctly, SQL 2005 database mirroring can only be used
to failover 1 database due to its inability to synchronize multiple
databases. Is that correct?
Thank You for your help,
yukon727

Hi

Yes you are quite correct - mirroring is configured on a 'per
database' basis. That doesn't mean that you can't have all 6 databases
mirrored independently, but if you had a failure of one database, only
that one would failover to the mirror and the remaining 5 would
continue to function on the principal server. If your application can
handle having connections pointing to multiple datasources, then thats
no issue but if, for example, you have queries that span these
databases then this is not a viable solution.

If you were to use DB mirroring on the premise that you are planning
for failover in the case of losing the entire server, then there isn't
a problem. However you would always have to live with the risk of a
single database failure.

.

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: 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)
  • 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)
Loading