SQLSERVER2005 announcement and subscription configuration steps

1, new announcement

Prerequisites: First to tune the network, select the MSSQLSERVER protocol in SQL Server Configuration Manager to change named Pipes to Enabled. Second to create a directory D:\backup and set up the share, everyone has read and write permissions

Detailed procedures such as the following:

After the changes, click on the copy of the local announcement, right click, new announcement

Click Next

Click Next

Select the first option click Next

You need to select the location of the snapshot the first time you create it, and you can fill in the shared directory each time you create the default location for the publication. This position can also be modified at the same time, and the location of the snapshot can be modified within the property after the advertisement is created. Select Next

Select the database you want to publish and choose Next

Select Things to announce and choose Next

Select the object you want to publish. Can be a specific table or process can be all objects

Default settings. Select Next

The ability to select the scheduled time in the change. Choose the one you want

Select OK next

Choose to perform a connection announcement server under the SQL Server Agent service account Select SQL Login

Click Next

Click Finish

Click on the publication right click on the property change Snapshot directory

Click Properties to select a shared directory

The directory location that you put in is the shared directory, and the publication creation succeeds

2.1.2 Creating a Subscription

Click Copy announcement below, follow the above steps to create a new advertisement, right click, New subscription

Click Next

Click Join SQL Server Subscriber

Click button on the right to set Distribution Agent security

Click OK

Click Next

Click Next

Click Next

Click Next

Click Finish

2.1.3 Subscription Announcement Test Summary:

Summary of announcements and subscriptions:

.1 The primary Servermssqlserveragent service must be started.

.2 changes to the stored procedure and changes to the table structure and fields only need to be operated on the primary server, and the standby server updates itself, and the addition and deletion of the data is the same effect.

.3 The new and deleted operations of the stored procedure and the table need to be canceled before the publication state, then the operation, the change completes and then creates the advertisement.

.4 primary keys are required for tables published by the master server.

Please join in time to check the subscription server, can check whether there is an advertisement unsuccessful subscription creation success, can click the advertisement right-start Replication Monitor to see the implementation of the published subscription, whether error, etc.

SQLSERVER2005 announcement and subscription configuration steps