SQLSERVER2005 release and subscription configuration steps

1, New release

Prerequisites: The first to adjust the network, in SQL Server Configuration Manager Select MSSQLServer protocol Named pipes to enable, the second to establish a folder D:\backup and set up sharing, everyone Have read and Write permissions

The steps are as follows:

Click Copy to edit the local post, right click, New release

Click Next

Click Next

Select the first option click Next

The first time you create a location to select the snapshot, this location every time you create the default location of the publication, you can fill in the shared folder, and this location can be changed, after the creation of the publication, you can change the location of the snapshot in the properties. Select Next

Select the database you want to publish and choose Next

Select Things to publish and choose Next

Select the object you want to publish, which can be a specific table or procedure or all objects

Default settings, select Next

You can select the time you want to schedule in the change, select the

Select OK next

Choose to run the connection Publisher under the SQL Server Agent service account Select SQL Server login

Click Next

Click Finish

Click Publish right click on properties to modify snapshot folder

Click Properties to select Shared Folders

The folder location that you put in is the shared folder, and the publication was created successfully

2.1.2 Creating a Subscription

Click on the copy release below, press the above steps to create a new publication, right click, New subscription

Click Next

Click Add SQL Server Subscriber

Click the 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 Release Test summary:

Summary of publications and subscriptions:

.1 The primary server Mssqlserveragent service must be started.

.2 The modification of the stored procedure and the modification of the table structure and fields only need to be operated on the primary server, the standby server is updated automatically, and the addition and deletion of the data is the same effect.

.3 New and deleted operations for stored procedures and tables, you need to cancel the publication state, then manipulate it, and then create the publication before you modify it.

.4 tables published by the primary server must have a primary key.

Please add a check to the Subscriber in time to check if there is a successful publication, you can click Publish Right button to start Replication Monitor to view the operation of the published subscription, whether error, etc.

SQLSERVER2005 release and subscription configuration steps