AaronAbend
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
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
he probably means that you cannot mirror the database to the same server/instance.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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
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