Home > IT Answers > SQL Server > Do you have to break the replication after you install a service pack in SQL Server 2005?
SQL Server Ask the Experts
2,585 pts.
 Do you have to break the replication after you install a service pack in SQL Server 2005?
SQL Server installation, SQL Server replication, SQL Server upgrades
In SQL Server 2005 when you install a service pack - do you have to break the replication as you did in SQL Server 2000 - and then reestablish the replication?

Software/Hardware used:
ASKED: March 11, 2008  10:08 PM
UPDATED: March 12, 2008  6:52 AM
RELATED QUESTIONS
Answer Wiki:
No you do not have to remove the replication when installing the SQL Server service packs. You shouldn't have had to do this in SQL 2000 either. It's been a while since I've had to service pack a SQL 2000 machine with replication setup, but I don't remember having to break the replication.
Last Wiki Answer Submitted:  March 12, 2008  6:52 am  by  Denny Cherry   64,505 pts.
All Answer Wiki Contributors:  Denny Cherry   64,505 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _