Transactional Replication : How to configuration in SQL Server 2008



Transactional Replication : How to configuration in SQL Server 2008

Transactional Replication : How to configuration in SQL Server 2008

In this Video Tutorial you will learn:-

How to configure SQL Server 2008 Database Transactional Replication.
What network protocol you should enable.
How to open ports on the windows firewall for SQL Server communication on the network.

SQL Server Ports to be open for Replication: 1433, 137.

Transactional replication mainly used in scenarios that require server to server high throughput, which includes: scalability and availability; data warehousing and reporting; integrating data from multiple sites; integrating heterogeneous data; and offloading batch processing.

Download Deme-Replication database backup:
http://tech.petercrys.com/2013/06/sql-server-2008-database-transactional.html

Also See:-
How to Automate SQL Server express backups on Windows Server 2012
http://youtu.be/hrE85Km7ync

Planning and Architecture (Replication)
http://technet.microsoft.com/en-us/library/bb500348(v=sql.105).aspx

Comments are closed.