Database Recovery

Understanding the Types of Failovers in SQL Server AlwaysOn Availability Groups

In this article, we look into failover options present in AlwaysOn Availability groups in MS SQL Server In layman’s terms, AlwaysOn Availability Groups can be considered as a form of disaster recovery solution which also helps in increasing the availability of database. Availability Groups support failovers in SQL Server. And it is important to note that failovers are not caused due to any issues with database, such as corruption or unavailability. The failover environment is supported by...

Read more »

How to Implement SQL Server with a Private Cloud – A Primer

In this article we check out why it makes sense to implement SQL Server with a private cloud solution Using disk storage, off-site premises, or even Azure Cloud for storing SQL Server data is old school. Private Cloud for storing SQL Server data is the new storage trend. There is now a distinction being created between a public cloud and a private cloud. This is currently what the IT industry is clouded by. Although the trend of private cloud storage hasn’t really gained momentum yet, it...

Read more »

SQL Server High Availability – What It Means and How Is It Measured

In this article, we understand the concept of High availability from different perspectives. High Availability for any kind of software or service is always determined by the kind of experience and expectation held by the end user. Downtime is usually characterized by multiple factors such as loss of information, decreased productivity, property damage etc. The purpose of high availability is primarily to reduce the downtime and its impacts as much as possible. Creating a sound strategy for...

Read more »