February 7, 2011 at 11:12 pm
Dear All,
Can some one advise me on this? please
In Database Mirrorring, if databases 1,2,3 & 4 on Instance A are mirrored ( High Protection Mode) to Instance B and
an error occured to only Database 3, then only Database 3 would failover to Instance B.
What will happen for the database 1,2 and 4 on Instance A?
How many databases can be mirrored as per server?
Thanks and Regards,
Ravi.
February 8, 2011 at 1:14 am
What will happen for the database 1,2 and 4 on Instance A?
They'll carry on running on Instance A.
How many databases can be mirrored as per server?
Depends. Network bandwidth, server resources. I know there are recommendations, maybe try a google search.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply