High Availability

RSS
man sprinting through datacenter

SQL Server High Availability with Amazon EC2

  • Jul 23, 2014
    Education

    Session 2: Creating Synchronous, Asynchronous and Read-Only Replicas  

    Running Time: 56 minutes | In this session, you'll see how you can create AlwaysOn Availability Groups that contain both synchronous and asynchronous replicas. You'll also see how you can offload reporting and backups to read-only replicas....More
  • Jul 23, 2014
    Education

    Session 3: Creating AlwaysOn Availability Groups in Azure  

    Running Time: 50 minutes | In the final session, you'll see how you can create SQL Server AlwaysOn Availability group replicas in Azure and use them for cloud-based disaster recovery....More
  • man sprinting through datacenter
    Oct 30, 2013
    blog

    SQL Server High Availability with Amazon EC2

    DataKeeper Cluster Edition from SIOS Technology can be used to provide a SQL Server high availability solution within the Amazon EC2 environment....More
  • Aug 1, 2013
    blog

    Massive Speed and High Availability

    One of the things people are always trying to figure out is how to get high-speed disks and high availability (HA) all in a single package. A possible solution is the DataKeeper Cluster Edition from SIOS Technology....More
  • Nov 17, 2011
    blog

    SQL Server 2012 Release Candidate Offers New Capabilities

    Microsoft's SQL Server 2012 Release Candidate 0 is now available for download and include new capabilities over the SQL Server Denali CTP3 release....More

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
May 18, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 24: Synchronizing SSIS Packages

In my previous post I covered options for adding “If-checks” into SSIS Packages – or SQL Server Maintenance Plans (which are, effectively, specialized SSIS packages). Once you’ve tackled that process, you’ll need to tackle something else when it comes to managing SSIS packages in conjunction with AlwaysOn Availability Groups. Or, more specifically, you’ll actually need to tackle two tasks....More
May 13, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 23: Maintenance Plan Backups and SSIS Packages

In my last post, we took a look at some of the details involved in actually implementing backups against databases being hosted in AlwaysOn Availability Groups. In addition to providing a high-level overview of how sys.fn_hadr_backup_is_preferred_replica() works, I also mentioned that integrating it into backups managed by SQL Server Maintenance Plans isn’t as easy as what you’ll run into with other types of backups....More
Apr 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 22: Executing Backups

Ultimately, there are a number of ways that DBAs can regularly create backups of their databases. Some of the more common options for managing backups include:...More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×