Microsoft SQL Server replication must be disabled before upgrading a site (with either a new service pack or version). After the site has been successfully upgraded, you can reconfigure SQL Server database replication.

Local subscriptions to the site database replica are not deleted on SQL Server subscriber computers. After disabling SQL Server database replication on the site database server (publisher), you must manually delete local subscriptions on SQL Server subscriber computers.

The following procedures can be used to disable SQL Server database replication for the site database.

Note
These procedures must be performed in the SQL Server 2005 SQL Server Management Studio console connected to the SQL Server hosting the site database.

To disable SQL Server 2005 database replication

  1. In the SQL Server 2005 SQL Server Management Studio console connected to the SQL Server hosting the site database, navigate to <SQL Server name> \ Replication.

  2. Right-click Replication and click Disable Publishing and Distribution to launch the Disable Publishing and Distribution Wizard.

  3. On the Disable Publishing and Distribution Wizard welcome page, click Next (if displayed).

  4. On the Disable Publishing page, select Yes, disable publishing on this server. Disabling publishing on the server will:

    • Drop all publications on the server.

    • Drop all subscriptions to all publications on the server.

    • Disable the server as a distributor.

  5. On the Confirm Dropping of Publications page, click Next.

  6. On the Wizard Actions page, select Disable publishing and distribution and click Next.

  7. On the Compete the Wizard page, click Finish.

  8. On the Disabling Distribution page, review the progress as SQL Server disables publishing and distribution. Once publishing and distribution has successfully been disabled, click Close to exit the Disable Publishing and Distribution Wizard.

To delete local subscriptions to the replicated site database

  1. In the SQL Server 2005 SQL Server Management Studio console connected to the SQL Server subscriber computer, navigate to <SQL Server name> \ Replication \ Local Subscriptions \ <site database replica subscription name>.

  2. Right-click <site database replica subscription name> and then click Delete.

  3. Click Yes to confirm subscription deletion when prompted.

See Also