SQL Always On for FIM

I wasn't able to find any information regarding the support of SQL Always On

Does FIM support SQL Always On? If not what should I use? Cluster? Mirr

November 19th, 2014 8:55am

Hello,

AlwaysOn and Mirroring is currently not suported.

You can use Failover Cluster for FIM Sync and Service DB.

See also this technet post: https://social.technet.microsoft.com/Forums/en-US/6a482712-c283-48f2-a175-1ab4f13b964d/fim-support-for-sql-2012-alwayson?forum=ilm2

-Peter

Free Windows Admin Tool Kit Click here and download it now
November 19th, 2014 9:25am

https://social.technet.microsoft.com/Forums/en-US/27dde96a-5305-446c-a3e8-edc2e617c55c/sql-2012-always-on-availability-groups?forum=ilm2

As Peter says: clustering is supported, mirroring is not, always on database availability groups are not, log shipping is not. Automatic failover with mirroring or database availability groups will not work. Mirroring itself works, just not the failover. Albeit you have a big performance hit even in asynchronous mode. Ditto for Availability groups. Log Shipping works, but you do have to pay attention to the management of the log. Again, Mirroring, Availability Groups and Log Shipping are not supported by Microsoft FIM Product group but they will work to the extent described and with the caveats described. So think carefully on what you want to do, being in an unsupported position isn't fun. Clustering can accomplish the goal of high availability. If I had to pick one for providing DR in case of site failure I would pick log shipping. But again not supported and you must pay attention to your log management or you could suffer performance hits.

November 19th, 2014 11:06am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics