troubleshooting Question

SQL Server 2008 R2 Database Mirroring

Avatar of cheryl9063
cheryl9063Flag for United States of America asked on
Microsoft SQL Server 2008Microsoft SQL Server
5 Comments1 Solution461 ViewsLast Modified:
We are considering using Mirroring for a server that will be used for reporting. My first question is if our Production Server is called A and the new reporting server will be called B. Will the A be the principle and B be the Mirror?  I want to use high-performance mode. I want users to be able to select from(read only) the mirrored server. Can you tell me if this will work or do I have to do some sort of snapshot or what?.. We have a replicated server but since the vendor refuses to add PK's to some tables we can not replicate those tables which is why we are looking at Mirroring for our SQL Server 2008 R2 servers.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros