Now that you have AlwaysOn configured and your first Availability Group (AG) created, it’s time to start leveraging those secondary...  Read more...

Read more...

SQL Server has produced some excellent High Availability options, but I was looking for an option that would allow me to access my secondary database without it being read-only or in restoring mode. I need the ability to see transactions occur and query the secondary database.  Read more...

Read more...

This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.  Read more...

Read more...

Read more...

This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. The document covers setting up replication in a mirrored environment, the effect of mirroring partnership state changes, and the effect of mirroring failovers on replication. In addition, it describes how to use LSN-based initialization to recover from the failover of a mirrored Subscriber database.  Read more...

This great tutorial shows how to set up database mirroring across two instances in a virtual environment.  Read more...

Read more...

Learn how you can setup Database Mirroring using disparate file paths and drive letters.  Read more...

Read more...

Today Steve Jones talks about licensing and the complexity if brings in various scenarios. Do your passive servers have to be licensed? What is the definition of "passive"?  Read more...

Wesley has heard High Availablity touted as all sorts of technological cure-all for busy SysAdmins and DBAs, and now he's taking a stand against it. There are a range of things that High Availability is regularly confused with (either deliberately or innocently), and Wesley's clearing it all up  Read more...

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance  Read more...

I have installed and uninstalled several instances of SQL Server in the past. Today, I need to uninstall a SQL Server 2008 R2 clustered instance. I have never uninstalled a clustered instance of SQL Server before. Can you provide a how-to guide to uninstall a clustered instance of SQL Server 2008 R2?  Read more...

Describes how to convert database mirroring to log shipping in SQL 2005/2008.  Read more...

Read more...

Adding and removing nodes in SQL Server Clusters is not so difficult, and instructions on how to do so abound on the internet. However, mismanagement when adding/removing nodes can quickly become a 'gotcha' that wastes time. Bo Chen offers insight into some of those scenarios that are not normally covered in the standard online documents.   Read more...

Log shipping is a tool that has more benefits than just recovering from a major disaster. Steve Jones thinks this might be a tool that DBAs should use for all their critical databases.  Read more...