I have a merge replication set up with a SQL 2000 publisher and an MSDE
subscriber. We are at a point where we are considering upgrading the MSDE
install to SQL 2000. I know the install/upgrade process is relatively simple.
Are there any precautions or issues with replication in upgrading from MSDE
to full SQL.
Thank you,
JH
No there are none, I take it that you are using push subscriptions correct?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"halej51" <halej51@.discussions.microsoft.com> wrote in message
news:B964744D-12EE-4E37-A565-D8C9EC26BA06@.microsoft.com...
> I have a merge replication set up with a SQL 2000 publisher and an MSDE
> subscriber. We are at a point where we are considering upgrading the MSDE
> install to SQL 2000. I know the install/upgrade process is relatively
simple.
> Are there any precautions or issues with replication in upgrading from
MSDE
> to full SQL.
> Thank you,
> JH
>
|||Yes,
The replica/snapshot resides on the publisher.
Thank you for the answer.
"Hilary Cotter" wrote:
> No there are none, I take it that you are using push subscriptions correct?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "halej51" <halej51@.discussions.microsoft.com> wrote in message
> news:B964744D-12EE-4E37-A565-D8C9EC26BA06@.microsoft.com...
> simple.
> MSDE
>
>
Showing posts with label upgrading. Show all posts
Showing posts with label upgrading. Show all posts
Tuesday, March 20, 2012
Friday, March 9, 2012
Replication - SQL Server 2000 - 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? And if this is the case is there a workaround? Like a
script that upgrades the user databases to 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? Right?
Many Thanks,
Nina
You cannot restore a backup of a replicated database from a different version
of SQL Server 2000. This is because replication updates user databases
(rather than just system databases) when the service pack is applied, and a
restored SP3 database may have replication metadata that is incompatible with
SP4 replication. User databases participating in a replication topology must
be online and accessible during upgrade to SP4 so that updates can be made.
I'm not sure if there is a separate script just to update user databases to
SP4, it may be part of the overall replication upgrade scripts. At any rate,
the recommended process is to let SP4 Setup perform the upgrade.
Glenn Gailey
SQL Server User Education
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nina" wrote:
> 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? And if this is the case is there a workaround? Like a
> script that upgrades the user databases to 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? Right?
> Many Thanks,
> Nina
>
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? And if this is the case is there a workaround? Like a
script that upgrades the user databases to 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? Right?
Many Thanks,
Nina
You cannot restore a backup of a replicated database from a different version
of SQL Server 2000. This is because replication updates user databases
(rather than just system databases) when the service pack is applied, and a
restored SP3 database may have replication metadata that is incompatible with
SP4 replication. User databases participating in a replication topology must
be online and accessible during upgrade to SP4 so that updates can be made.
I'm not sure if there is a separate script just to update user databases to
SP4, it may be part of the overall replication upgrade scripts. At any rate,
the recommended process is to let SP4 Setup perform the upgrade.
Glenn Gailey
SQL Server User Education
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nina" wrote:
> 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? And if this is the case is there a workaround? Like a
> script that upgrades the user databases to 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? Right?
> Many Thanks,
> Nina
>
Subscribe to:
Posts (Atom)