Sql Server2008

Implementando replicacion sql server 2008

Creating Windows Accounts for Replication
Note: |
In the replication tutorials, the Publisher and Distributor share the same instance of SQL Server. The Publisher and Subscriber may share the same instance of SQL Server, but it is not a requirement. If the Publisher and Subscriber share the same instance, the steps that are used to create accountsat the Subscriber are not required. |
To create local Windows accounts for replication agents at the Publisher
1. At the Publisher, open Computer Management from Administrative Tools in Control Panel.
2. In System Tools, expand Local Users and Groups.
3. Right-click Users and then click New User.
4. Enter repl_snapshot in the User name box, provide the password and otherrelevant information, and then click Create to create the repl_snapshot account.
5. Repeat the previous step to create the repl_logreader, repl_distribution, and repl_merge accounts.
6. Click Close.
To create local Windows accounts for replication agents at the Subscriber
1. At the Subscriber, open Computer Management from Administrative Tools in Control Panel.
2. In System Tools,expand Local Users and Groups.
3. Right-click Users and then click New User.
4. Enter repl_distribution in the User name box, provide the password and other relevant information, and then click Create to create the repl_distribution account.
5. Repeat the previous step to create the repl_merge account.
6. Click Close.

Preparing the Snapshot Folder

To create a share for thesnapshot folder and assign permissions
1. In Windows Explorer, navigate to the SQL Server data folder. The default location is C:\Program Files\Microsoft SQL Server\MSSQL.X\MSSQL\Data.
2. Create a new folder named repldata.
3. Right-click this folder and click Sharing and Security.
4. On the Sharing tab in the repldata Properties dialog box, click Share this folder. Ensure that the Sharename value is repldata.
5. Click Permissions.
6. Click Add. In the Enter the object names to select text box, type the name of the Snapshot Agent account created in Lesson 1, as <Machine_Name>\repl_snapshot, where <Machine_Name> is the name of the Publisher. Click Check Names, and then click OK.
7. Repeat the previous step to add permissions for the Distribution Agent, as<Machine_Name>\repl_distribution, and for the Merge Agent as <Machine_Name>\repl_merge.
8. Verify the following permissions are allowed:
* repl_snapshot - Full Control
* repl_distribution - Read
* repl_merge - Read
9. Click OK to close the Permissions for repldata dialog box.
10. Click Security, and then click Add.
11. In the Enter the objectnames to select box, type the name of the Snapshot Agent account created in Lesson 1 as <Machine_Name>\repl_snapshot, where <Machine_Name> is the name of the Publisher. Click Check Names, and then click OK.
12. Repeat the previous step to add permissions for the Distribution Agent, as <Machine_Name>\repl_distribution, and for the Merge Agent as <Machine_Name>\repl_merge.13. Verify the following permissions are allowed:
* repl_snapshot - Full Control
* repl_distribution - Read
* repl_merge - Read
14. Click OK to close the repldata

Configuring Distribution
Antes verificar el nombre de los servidores para el SQL server
Configuring distribution at the Publisher
1. Connect to the Publisher in SQL Server Management Studio, and thenexpand the server node.
2. Right-click the Replication folder and click Configure Distribution.
The Distribution Configuration Wizard launches.
3. On the Distributor page, select '<ServerName>' will act as its own Distributor; SQL Server will create a distribution database and log, and then click Next.
4. Enter \\<Machine_Name>\repldata in the Snapshot folder text box,...