Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have 2 Physical Servers with SQL Server 2008 R2. – SQL Server 1(Active) & SQL Server 2 (Passive) Web Application is developed using .Net 4.0 Framework.

I want to know the best solution to have high availability and also have SSRS for reporting.

Planned solution: Mirroring for Failover, and Transaction Replication for SSRS as the mirrored database can only be used for failover scenarios. SSRS will be on the Passive server, to reduce the load on the Active server.

Let me know if the solution is correct. Also suggest alternate approaches.

share|improve this question

1 Answer 1

It depends.

Best solution is what provides the optimal support for your needs without requiring extra effort. :)

With two servers, I have to wonder where you plan to put the Replication results? If on the same server as the principal, that might become very interesting. This Microsoft article (Replication and Database Mirroring, http://msdn.microsoft.com/en-us/library/ms151799.aspx) discusses configuring Replication with Mirroring. Believe, this is well documented, but not for the faint of heart.

What is the driving need for Replication?

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.