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:-
https://www.youtube.com/watch?v=sbrUtfkkVUE  


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

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

30 comments:

  1. Thanks for this information; I hope it will use much reader who looking you regularly likes me…
    Regards,
    Informatica training in chennai

    ReplyDelete
  2. I like your writing style, it was very clear to understanding the concept well; I hope you ll keep your blog as updated.
    Regards,
    sas training in Chennai|sas course in Chennai

    ReplyDelete
  3. this windows tutorial blog is really great it is nice and informative and unique too thanks for sharing this information.

    sas training in chennai

    ReplyDelete
  4. Being a SAS analyst would be the right choice.JoinFITA offers a good training and it helps to achieve a good career.
    Regards,
    SAS Training Institute in Chennai | SAS Training in Chennai

    ReplyDelete
  5. Very Nice Tutorial Blog.. Thanks for sharing it.

    CCNA training in Chennai

    ReplyDelete
  6. Wonderful post. I like your blog. Thanks for sharing.

    seo training in chennai

    ReplyDelete
  7. Great article. Happy to visit your website. Keep sharing such a useful post.

    web design training in chennai

    ReplyDelete
  8. Truly an awesome post.Keep up your astonishing work and keep sharing.
    Hadoop Training in Chennai | Hadoop course in Chennai

    ReplyDelete
  9. This data is great and amazing. A debt of gratitude is in order for taking an ideal opportunity to talk about this, I feel upbeat about it and I adore adapting more about this theme. I utilize your manual for teach my understudies.Keep sharing more.
    ccna Training in Chennai | ccna courses in Chennai | ccna Training institutes in chennai

    ReplyDelete
  10. This substance makes another trust and motivation within me. A debt of gratitude is in order for sharing article this way. The way you have expressed everything above is entirely amazing. Continue blogging this way.
    DOTNET Training in Chennai | DOTNET course in Chennai | DOTNET Training Institute in Chennai

    ReplyDelete
  11. Heavenly I truly delighted in especially with this article here. Truly it’s a stunning article I had ever perused. I seek it will help a ton after all. Much obliged to you such a great amount for these astounding posts and please keeps upgrade like this fantastic article.
    Regards,
    SAS Training in Chennai | SAS Training Institute in Chennai | SAS Training Chennai

    ReplyDelete
  12. It's really a good topic to post articles, you explained well about the necessity of network virtualization :)
    DOT NET Training in Chennai|DOT NET Training Institutes in Chennai

    ReplyDelete
  13. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Python Training in Chennai | Python Course in Chennai

    ReplyDelete
  14. Thank you for sharing in this webpage, I can learn a lot and could also be a reference, I hope to read the next your article updates.
    Regards,
    ccna Training in Chennai | ccna institutes in Velachery | ccna Training institutes in Velachery

    ReplyDelete
  15. Thanks for sharing this unique and informative content which provided me the required information.
    Java Training in Chennai | JAVA Course in Chennai

    ReplyDelete
  16. It's very best beneficial blogs.I read this subjects blog such a great blog and good sharing I'll be like this information post.Selenium Training in Chennai | Selenium Training Institute in Chennai

    ReplyDelete
  17. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing. Selenium Training in Chennai | Selenium Course in Chennai

    ReplyDelete
  18. very informative blog. Helps to gain knowledge about new concepts and techniques. Thanks for posting information in this blog…I found lots of interesting information here.Great work.
    Video editing institute in chennai

    ReplyDelete
  19. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information&its very useful to me...
    Android training in chennai
    Ios training in chennai

    ReplyDelete
  20. Good and nice article, thanks for sharing your information and views... keep post and rocks as well...
    Dot Net Training in chennai | Dot Net Training in velachery

    ReplyDelete
  21. The best thing is that your blog really informative thanks for your great information..Java Training Institute in Chennai | Java Training Institute in Velachery

    ReplyDelete