New Microsoft SQL Server Video Tutorial: Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication

Pt. 1 - Setting Up the Distributor and Publisher for Transactional Replication - view details

This video is a continuation from our introductory series on SQL Server replication and walks you through setting up the distributor and the publisher for transactional replication. You'll walk through setting up replication using the "Configure Distribution Wizard" to configure each option. Included is a detailed explanation of each of the screens in the wizard and recommendations for best practices.

Highlights from this video:

• Replication architecture
• What is the "distribution" database?
• Suggestions for configuring the SQL Server agent for replication
• What is the snapshot? Where is it stored? How often should it be generated?
• Scripting the wizard's output for easier replay/debugging/maintenance
• Using the Replication Monitor
• Using the Distributor Properties and Publisher Properties

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Replication in SQL Server
• Skill Level: 200 (Beginner - Intermediate)
• Length: 13:12 (8.74MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: replication architecture, transactional, beginning, beginner, intro, introduction, snapshot folder, snapshot