Home > Podcast: SQL Server replication basics
Podcast:
EMAIL THIS

Podcast: SQL Server replication basics

20 Jun 2007 | SearchSQLServer.com

Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

In this podcast, you'll grasp the functionality of replication and what it can do for your SQL Server environment. SQL Server database administrator Eric Johnson starts by explaining the three replication types: snapshot, transactional and merge. He then takes you through setting up replication for high availability and outlines how to failover a replication solution.

  Podcast 

  • Download the podcast: SQL Server replication


  •   Podcast highlights 

  • Total run time: 10:32

  • (0.57) What is replication, describe the three types?

  • (2.56) How can replication be used for High Availability?

  • (5.27) Beyond replication, what must you consider when setting up High Availability?

  • (7.52) How do you failover a replication solution?

  •   Related tips and guides:  

  • Replication techniques in SQL Server: This collection of expert advice will guide you on how to enhance your techniques when replicating your SQL Server database(s).

  • Optimize merge replication performance: Improve merge replication performance with the methods explained here and have that highly scalable SQL Server environment.

  • Replicated stored procedure options with SQL Server 2005: Replicating stored procedures between SQL Server environments is a process for which you have many technologies to choose from. Get to know your options in this tip.


    ABOUT THE AUTHOR:   
    Eric Johnson (MCSE, MCITP: Database Administrator, MCSD) is co-founder of Consortio Services and the primary Database Technologies Consultant. He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Eric has presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He is president of the Colorado Springs SQL Server Users Group.

    You can see Eric at the Highly Available SQL Solutions seminar in Denver, CO on July 26th and 27th. Learn rock solid solutions with in depth coverage of clustering, mirroring, log shipping, replication and disaster recovery.



    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



    RELATED CONTENT
    SQL Server Replication
    SQL Server Mailbag: Migrating down to Standard Edition
    Push vs. pull: Configuring SQL Server replication
    Top load balancing methods for SQL Server
    New replication features in SQL Server 2008 and what they mean to you
    SQL Server database replication tutorial
    Licensing a standby server for SQL Server replication
    Upgrade live applications to SQL Server 2005 for high availability
    Tool to synchronize two SQL Server databases
    Simplify SQL Server replication
    Replication techniques in SQL Server

    SQL Server High Availability, Scalability and Reliability
    Are data warehouses made for the cloud?
    Top load balancing methods for SQL Server
    Maintaining high availability of SQL Server virtual machines
    Creating fault-tolerant SQL Server installations
    Scaling up vs. scaling out with SQL Server 2008
    How to configure storage in SQL Server database with more writes than reads
    SQL Server database replication tutorial
    Licensing a standby server for SQL Server replication
    Get SQL Server log shipping functionality without Enterprise Edition
    Monitor database mirroring and replication after a SQL Server upgrade
    SQL Server High Availability, Scalability and Reliability Research

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    replication  (SearchSQLServer.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary




  • Secure SQL - Data Security for Your Database
    HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Site Map




    All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
      TechTarget - The IT Media ROI Experts