Home > Podcast: SQL Server replication basics
Podcast:
EMAIL THIS LICENSING & REPRINTS

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
    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
    Synchronize databases on two separate active servers
    SQL Server Blog Watch
    Simplify SQL Server replication
    Replication techniques in SQL Server
    Podcast: SQL Server high availability options
    Managing identity columns with replication in SQL Server
    Optimize merge replication performance

    SQL Server availability
    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
    Upgrade live applications to SQL Server 2005 for high availability
    SQL Server high availability when upgrading to SQL Server 2005
    Tutorial: Migrating to SANs from local SQL Server disk storage
    How to restore SQL Server database to transition server during upgrade
    SQL Server memory configurations for procedure cache and buffer cache
    Upgrade Active/Active cluster to SQL Server 2005 and Windows 2003
    SQL Server backups using SAN database snapshots
    SQL Server availability 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


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

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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