Hi All, I am a DBA. In our organization we are using SQL Server 2012. So far, the High Availability concepts that I have worked are Mirroring & Log shipping. Now, we are planning to implement "Always on" in our organisation, which is new to all of us. My doubt is, when windows server failover clustering is enabled on the secondary server, can the same server be used as secondary IIS/mail/file server. Moreover, We need to test "Always on" in our current secondary server(which is now used for mirroring) and testing shouldn't disturb the current setup. Is that possible? Please advise us in this regard. Thanks in advance. K.P.Senthil Kumar
Not sure if you are talking about Always on as in Failover Cluster or Availability groups since both use failover clustering. Either way you are way off when you are thinking about sharing an "Always On" server with other services such as IIS/MAIL. You should not test this in your production environment either, I am not sure how you can test any always on feature on one server? Separate test from production. Separate SQL and all other features. And get other server for Always on. If they wont gice you new servers, do not go always on. It will be always off in the end..
Can you run an availability group and a mirroring set up on the same set of servers? Yes. Can you install an availability group onto an existing set of servers running mirroring without affecting mirroring? Probably not. At the very least you're likely to have to restart the server after getting the Clustering service started. The reboot alone will cause at least a temporary disruption of your mirroring set up.