SQL Server Performance Forum – Threads Archive

Replication and Service Pack 4

Hi, I am considering upgrading to SQL Server service pack 4 and would just like
to clarify. In the readme file for SP 4 if find the following: “Note If an instance of SQL Server is not part of a replication topology,
you can back up a user database and restore it on any other release of SQL
Server 2000.” Does this mean that I will not be able to restore a user database from a
instance running SP3 to a instance running sp 4 if it is part of a
replication topology with out reapplying sp 4? Scenario: Two environments: testing and production. I upgrade test to SP4
and then restore user databases from production (sp3). Replication is used
both in test and production, so the restored user databases that are involved
in replication will not longer work, because they are from an instance that
is sp3? Or? Many Thanks,
Nina

---

Before applying the SP4 anyway you have to take backups of all databases as a pre-cautionary measure, and when you apply SP4 then you must apply it to all the instances that are involved in the replication to avoid any issues in future. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

Thanks Satya, Backup is always a good idea! So, yes, I will do that. I am trying to find out what will happen if I take backup of replicated databases on a SP3 instance and restore it on a SP4 instance. There are two different environments and there is no replication between them. Every environment will be either all SP3 or all SP4.

---

I think no issues restoring SP3 backup to a SP4 instance, as the SP4 is the higher part of it. As long as you maintain similar levels of service pack between instances then no issues. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

---

]]>