SQL Server's snapshot replication technology allows you to automatically transfer information between databases to keep them synchronized. In this article, we look at the first step of the snapshot replication process: creating the replication distributor.
Time Required: 30 minutes
- Open SQL Server Management Studio and connect to the database server that you wish to serve as the distributor.
- Right-click on Replication and choose Configure Distribution from the pop-up menu.
- Click Next to advance past the welcome screen.
- Select " will act as its own Distributor; SQL Server will create a distribution database and log", then click the Next button to continue.
- Click the Next button to accept the default setting that SQL Server Agent should start automatically.
- Provide a location where SQL Server should store the snapshot replication files by providing either a local folder path or a UNC share name, then click Next to continue.
- Accept the default name and paths for the distribution database by clicking the Next button.
- If servers other than the distribution server will publish to this distribution server, provide their information and then click the Next button to continue.
- Click the Next button to advance to the confirmation screen.
- Review the choices presented in the Complete the Wizard screen and click Finish to configure your distributor.
What You Need
- Microsoft SQL Server 2008
- SQL Server Management Studio