Everything about database,how to,example,guide,

Carrying out the configuration that duplicate option must have to the system before duplicating,Basically include:
Publisher
The person that order
The person that distribute
Distribute a database
Through the Create Publication Wizard that SQL Server Enterprise Manager offers and The Configure Publishing And Distribution Wizard,Will make configure the job to become simple,Rapid.

16.2.1 founds a server part and distribute a database
Establishing server role is to point to in duplicate process some server is to serve as the publisher, person that distribute to still serve as the person that order.Because SQL Server can act one or more part,So we must be appointed the server acts what part by which.
Distribute a database (Distribution Database) all work that use the person that memory duplicates to order and publisher and the synchronous information of the person that order.In distribute a database to have a lot of with duplicate the system that concern is expressed.Before undertaking duplicating, must found above all distribute a database (the systematic watch that concerns with the system can be generated automatically) ,Appoint the publisher, publication database, person that distribute, person that order at the same time.Use SQL Server Enterprise Manager will found distribute a database to basically press the following measure:
(1) the SQL Server Enterprise Manager that start,The server of part of the person that pitch on prepares to play the part of show edition.
(2) in the choice on entree sheet individual event of Tools dish is in next pulling option of Replication of choose of the reelection in menu,Pitch on Configure
Publishing,Subscribers,Option of And Distribution,Can shoot a dialog box of Welcome To The Configure Publishing And Distribution Wizard right now.Place of the 16-5 that be like a graph is shown.

(3) can be informed from which can realize what duplicate configuration through this guide,Click " next " continue to operate,Shoot a dialog box of Select Distributor right now.Place of the 16-6 that be like a graph is shown.

Acquiescent option Make can be used in this dialog box ' XUJIN ' Its Own Distributor; SQL Server Will Create A Distribution Database And Log will appoint current publisher server to act part of the person that distribute,If choose this option,Can found to issue database and daily record on server of the person that distribute.If choose another option,The person that should notice to already must was to distribute by configuration by the server of make choice of and had founded distribute a database.In this use acquiesce option,
(4) click " next " ,Shoot a dialog box of Configure SQL Server Agent right now.Place of the 16-7 that be like a graph is shown.Options of choice Yes expresses to start SQL Server Agent automatically,Option of choice NO,Express to start SQL Server Agent by hand.

(5) click " next " ,Shoot a dialog box of Customize The Configuration.The option that if choose acquiesce,is in inside this dialog box.Namely No,Use The Following Default Setting,So SQL Server will configure duplicate option automatically,It will regard the person that distribute as current server,Distribute database and clerical log to be put below \MSSQL\data catalog,The server that all registering is chosen to be the person that order.You also can choose to define option oneself,Namely Yes,Let ' S... . Option comes the person that bisect is sent, publisher, person that order, distribute a database to undertake configuration (we are issueing to have specific introduction to its) .Here we choose acquiescent option.
(6) click " next " ,Hitting crosshatching next (if place of graph 16-8 is shown) in click " Finish " pushbutton,Can play a Configure Publishing And Distribution On of window of a report right now ' Server _name ' will show establish plan.Can understand SQL Server to complete what work through this window.


16.2.2 configures duplicate option
Founding a server part with what distribute a database,The configuration that SQL Server Enterprise Manager uses to be able to have duplicate option after and management,Basically include:
Configuration issues option
Set publishs option
The setting publishs a database
Install option of the person that order
Delete the person that distribute

[1] [2] [3] issues one page