Link to home
Start Free TrialLog in
Avatar of AaronAbend
AaronAbendFlag for United States of America

asked on

One-database limit on database mirroring?

A colleague has suggested that SQL 2005 database mirroring only supports one database per server. I cannot find any reference to this limitation but want to make sure. Was it a limitation on the original release or perhaps even a beta release?


Thanks

ASKER CERTIFIED SOLUTION
Avatar of imran_fast
imran_fast

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Guy Hengel [angelIII / a3]
he probably means that you cannot mirror the database to the same server/instance.

SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of imran_fast
imran_fast

The above topic shows you can do mirroring on multiple database per server but it is not recommended to do mirroring when your application spans multiple database.
Avatar of AaronAbend

ASKER

I found a powerpoint from a Microsoft presentation with the words "High availability for a single database" but the audio indicates that mirroring is done  on a "database by database basis" as distinct from a "server by server" basis. I think this is the source of the confusion. I think Imran's answer is best. Thanks for the quick reply.

for the benefit of those who find this thread... here is the Microsoft presentation with that slide...
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032282290&EventCategory=5&culture=en-US&CountryCode=US

and here is a discussion of mirroring multiple databases
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx#ECMAE