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

Pt. 3 - Setting Up Push 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 "Create Publication Wizard"
• Discussion of the Distribution Agent and how it works (does it run at subscriber?)
• Discussion of using non-SQL Server subscribers
• 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

• Category: Replication in SQL Server
• Skill Level: 200 (Beginner - Intermediate)
• Length: 14:55 (0.00MB)
• Applies to Versions: SQL Server 2000
• 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