New Microsoft SQL Server Video Tutorial: Pt. 3 - Setting Up Push and Pull Subscriptions

Pt. 3 - Setting Up Push and Pull Subscriptions - view details

This video walks you through setting up a push subscriptions and pull subscriptions as well as synchronizing servers. You'll be able to view latency and how to diagnose replication problems.

Highlights from this video:

• Push Subscriptions vs. Pull Subscriptions
• Synchronization Schedules and Latency
• How to initialize a new publication using the "New Publication Wizard"
• Discussion of the Distribution Agent and how it works (does it run at subscriber?)
• Discussion of using non-SQL Server subscribers (Oracle subscribers, DB2 subscribers for example)
• Discussion of service account usage and recommendations
• Snapshot initialization and how to start the Snapshot Agent
• Working with multiple subscriptions for a single publication

and much more

---

• Source: SQL Server videos
• Category: Replication in SQL Server
• Skill Level: 200 (Beginner - Intermediate)
• Length: 17:26 (14.7MB)
• Applies to Versions: SQL Server 2005
• Full Details

---

To download this video, Login, then visit the video's detail page and click "download". You might also enjoy our free training videos.

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

---

Keywords Associated with this video: replication architecture, merge, transactional, snapshot, dr, beginning, beginner, intro, introduction, publication, article, pu