The key takeaway of this exercise is that by following these steps, you can perform a rolling Edition Upgrade with an existing database mirroring partnership. You can do this without having to reinitialize your mirrored databases or take a longer outage while you are doing an Edition Upgrade of the active instance.\u00a0 You do have to have an existing mirroring partnership to make this work. This is because SQL Server will not let you create a new mirroring partnership between SQL Server Standard Edition and SQL Server Enterprise Edition.<\/p>\n","protected":false},"excerpt":{"rendered":"

Imagine that you are using synchronous database mirroring with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Standard Edition. Now, you want to upgrade the instances on both sides of the mirroring partnership to SQL Server Enterprise Edition.\u00a0 This will let you take advantage of some of the valuable […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,29,30,31],"tags":[75,74],"class_list":["post-482","post","type-post","status-publish","format-standard","hentry","category-sql-server-database-mirroring","category-sql-server-2008","category-sql-server-2008-r2","category-sql-server-2012","tag-database-mirroring","tag-edition-upgrade"],"yoast_head":"\n