Monday, June 24, 2013

SQL Server 2008 Database Transactional Replication

Transactional replication mainly used in scenarios that require server to server  high throughput, which including: scalability and availability; data warehousing and reporting; integrating data from multiple sites; integrating heterogeneous data; and offloading batch processing.
In order to complete this tutorial you required:-
First download the demo database which we are going to use in this tutorial Click Here to download or you can created your own database
1. You should have 2 virtual machines or 2 physical machines.
2. Machines OS has to be Windows server 2008 or Windows Server 2012.
3. Machines should have Microsoft SQL Server 2008 or Microsoft SQL Server 2008 r2 installed.
4. both machines should be able to commutate with each other.
5. SQL Authentication mode should be enable.
In this Video Tutorial you will learn:-
How to configure transactional replication on Microsoft SQL Server 2008
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.

 Scenario: You have a time critical database which required high availably if the server goes down everything will stop working and the loss will be implacable.
See the comprehensive Video Tutorial to configure transactional replication on SQL Server 2008:-  

= HI friends, ~(。◕‿◠。)~

= If You Like These Video Tutorials, Give It a Thumbs Up :)