SQL 2012 to 2014 in place

planning for in place upgrade  one of our server from 2012 to 2014.

Server is in replication.  Server planning for upgrade is subscriber and also publisher

I can disable replication flow from this server.  how do I stop replication flow in to this server.

Drop and readd subscription, will start reinitilization but i want to stop temporarily and restart after upgrade done

Thanks

v

May 18th, 2015 12:00pm

Start and Stop a Replication Agent 

https://msdn.microsoft.com/en-us/ms151783.aspx

Upgrade Advisor

https://msdn.microsoft.com/en-us/library/ms144256.aspx

upgration 

http://www.mssqltips.com/sqlservertip/3245/quick-guide-to-upgrading-to-sql-server-2014/

Free Windows Admin Tool Kit Click here and download it now
May 18th, 2015 12:14pm

There is no need to stop replication during the upgrade process.

May 18th, 2015 3:57pm

Hi Vaishu,

Besides other post, you can review the following article to get more details about upgrading replicated databases.

https://technet.microsoft.com/en-us/library/ms143699.aspx

Thanks,
Lydia Zhang

Free Windows Admin Tool Kit Click here and download it now
May 19th, 2015 3:44am

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

Other recent topics Other recent topics