Can we use SharePoint 2010 with SQL server 2014? At our organization we have our SharePoint farm which is currently on SharePoint 2010 with SQL server 2008 R2. We are undergoing an SQL server upgrades for all our database servers (We have technologies being used other than SharePoint) and we don't want to tie SQL upgrade process to SharePoint upgrade.
So my Question is if we can use SQL 2014 with SharePoint 2010 in any form by either running SQL server in compatibility mode or by installing any patches for SharePoint. If we can use it what are the chances that it might break something in SharePoint and how can I verify this before doing it in production environment (We have live content management website in SharePoint)? It would be great if someone who has used this combination could comment.