Home > Database mirroring in SQL Server 2005
Podcast:
EMAIL THIS LICENSING & REPRINTS

Database mirroring in SQL Server 2005

24 Jun 2007 | SearchSQLServer.com

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

What is database mirroring in SQL Server and how can it benefit your environment? SQL Server database administrator Eric Johnson starts by outlining the three roles involved in database mirroring: principle, mirror and witness. He goes on to share the types of mirroring solutions for High Availability and how to configure those solutions.

  Podcast 

  • Download the podcast: Database mirroring in SQL Server 2005


    •   Podcast highlights 

  • Total run time: 11:33

  • (0.50) What is database mirroring?

  • (2.04) What types of mirroring solutions are available and which is most appropriate for High Availability?

  • (6.07) How do you configure clients to work with a mirroring solution?

  • (9.24) Can you read the data stored in the mirror database?

    •   Related tips and guides:  

  • Database mirroring setup in SQL Server 2005: SQL Server 2005 database mirroring allows you to automatically mirror database contents. Learn how it works and how to get it up and running with Management Studio.

  • Q&A: Database mirroring in SQL Server 2005 and its witness: Database mirroring in SQL Server 2005 will increase your system's availability by allowing a quick and automatic failover. Learn more about the role of the witness.

  • SQL Server 2005 backup and recovery: 5 handy tips: Backup and recovery with SQL Server 2005 include several new features worthy of your attention. Here are five tips to help you take full advantage of these enhancements


    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 availability
    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
    Tips for moving from SQL Server local disk storage to SANs
    How to process SQL Server 2005 Analysis Services for data availability
    SQL Server 2005 log shipping setup using the wizard
    SQL Server availability Research

    SQL Server backup and recovery
    SQL Server backups using SAN database snapshots
    Tips for scheduling and testing SQL Server backups
    Code to restore SQL Server databases in VB.NET
    Tricking SQL Server into making full database backups
    SAN considerations for your SQL Server environment
    Top 7 SQL Server backup and restore tips of 2007
    Retrieve deleted tables in SQL Server
    SQL Server backup and restore commands to limit downtime
    Mirrored backup and restore commands in SQL Server 2005
    Set up a SQL Server disaster recovery site
    SQL Server backup and recovery Research

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    rollback  (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