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 :)

78 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
  22. It’s always good to learn tips like you share for blog posting. I just started posting comments for blog and facing problem of lots of rejections. I think your suggestion would be helpful for me. I will let you know if its work for me too. Thanks and keep post such a informative blogs.
    AngularJS Training Institute in Chennai
    AngularJS Cetification Training in Chennai
    AWS Training in Chennai
    AWS Devops Training in Chennai
    DevOps Certification in Chennai
    DevOPs Certification Training Institute in Chennai
    Best AngularJS Training in Chennai
    AngularJS Training in Chennai

    ReplyDelete
  23. Needed to compose you a very little word to thank you yet again regarding the nice suggestions you’ve contributed here. digital marketing training in chennai

    digital marketing training in bangalore

    ReplyDelete
  24. I really enjoyed while reading your article, the information you have delivered in this post was damn good. Keep sharing your post with efficient news.. Automation Anywhere Training in Chennai | RPA Training Institute in Chennai | UI Path Training Institute in Chennai

    ReplyDelete
  25. Very interesting blog which helps me to get the in depth knowledge about the technology, Thanks for sharing such a nice blog... Best CCNA Training Institute in Chennai | Best CCNP Training Institute in Chennai

    ReplyDelete
  26. I am very impressed with the article I have just read, so nice....PHP Project Center in Chennai | PHP Project Center in Velachery

    ReplyDelete
  27. Good and nice article, thanks for sharing your information and views... keep post and rocks as well...
    Image Processing Project Center in Chennai | Image Processing Project Center in Velachery

    ReplyDelete
  28. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    Selenium Training in Chennai

    Selenium Training in Bangalore


    ReplyDelete
  29. Appreciation for really being thoughtful and also for deciding on certain marvelous guides most people really want to be aware of.

    AWS Training in Chennai

    ReplyDelete
  30. Nice blog, here I had an opportunity to learn something new in my field. I have an expectation about your future post so please keep updates.
    white label website builder

    ReplyDelete



  31. Best Mobility Services
    Very good article. this bolg article are good and keep sharing more article.

    ReplyDelete
  32. Nice blog too informative. Looking and reading your points its so impressive. Doing more blog like this. I really appreciated doing like this..
    Summer Course Training Institute in Chennai | Summer Course Training Institute in Madipakkam

    ReplyDelete
  33. Thanks for sharing your useful and interesting blog with us.keep updating..
    Best Summer Courses in Pallikaranai | No.1 Summer Courses in Pallikaranai

    ReplyDelete
  34. Thanks for sharing this information.This is very useful for us.Technical Workshop in Chennai | Summer Courses in Chennai

    ReplyDelete

  35. Very nice information and explanation is good. Thanks for sharing. keep on updating such a nice information.
    Austere Technologies |Internet Of Things

    ReplyDelete
  36. I like your writing style, it was very clear to understanding the concept well.Thanks for sharing.

    Oracle Weblogic Server Training

    ReplyDelete
  37. Very good informative article. Thanks for sharing such nice article, keep on up dating such good articles.

    Best Software Security Services | Austere Technologies

    ReplyDelete
  38. This comment has been removed by the author.

    ReplyDelete
  39. Great article, really very helpful content you made. Thank you, keep sharing.

    Best Cloud Services | Austere Technologies

    ReplyDelete
  40. Good to be here found really very nice article, thanks much for sharing this wonderful article...
    Best Online Software Training Institute | Oracle DBA Training

    ReplyDelete
  41. Thank you Admin!
    Real time project center provides ECE projects in chennai

    ReplyDelete
  42. Quite Interesting post!!! Thanks for posting such a useful post. I wish to read your upcoming post to enhance my skill set, keep blogging.
    Regards,

    Embedded Project Centers in Chennai | Ece Projects in Chennai

    ReplyDelete
  43. Very useful this blog,it is very helpful for good my career.Thank you for sharing this useful blog.For Any information on project,please check our website.
    Vlsi Projects in Chennai | ME Projects Chennai.

    Thank You.

    ReplyDelete
  44. It is really very helpful for me and I have gathered some important information from this blog.

    Parallel Distributed Computing Projects in Chennai | Secure Computing Projects in Chennai.

    ReplyDelete
  45. Great information you are shared, Thanks for sharing most valuable information. keep share on

    IEEE IOT Projects in Chennai | IEEE Arduino Projects in Chennai.

    ReplyDelete
  46. This Blog Provides Very Useful and Important Information. I just Want to share this blog with my friends and family members. United States Medical Licensing Examination

    ReplyDelete
  47. Thank you for sharing this valuable information. But get out of this busy life and find some peace with a beautiful trip book Best Andaman Tour Package

    ReplyDelete
  48. I got a lot of great information from this blog. Thanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
    Graphic Designing Training Course in Chennai | Graphic Designing Training Course in Velachery

    ReplyDelete
  49. Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site.
    Graphic Designing Training Course in Chennai | Graphic Designing Training Course in Velachery

    ReplyDelete