Sidd's SQL Solution

Hope this New Year had brought good time to all my blog readers. After a small break, I’m back with a very interesting blog post, which I’ve prepared on an interesting problem I faced recently. If you’re planning to use database mirroring as a solution to create secondary backup\failover site for your database, which is serving as backend database to your .Net Application hosted on the IIS Server then this is one of the things you need to consider apart from other pre-requisites. Scenario We had two databases running on different versions of SQL Server. One hosted on SQL Server 2008 R2 SP3 instance and another database was on SQL Server 2012 SP1 instance (both were stand-alone). We had two different applications connecting to these databases respectively, one application hosted locally and other one on remote IIS server. Problem The applications were running fine and without any problems in production and were able to access and work with test databases created on the r