Posted on

SQL Server Fast Recovery: What Is It and When Is It Needed?

Fast recovery is a feature in SQL Server Enterprise edition that allows accessing a database once the REDO (i.e., committed transactions are rolled forward) phase completes before the UNDO (i.e., uncommitted transactions are rolled back) phase gets complete. This article will talk in detail about the SQL Server Fast Recovery feature, when it is used, and when it can't be used. Also, the article discusses an alternative to performing a database restoration when Fast Recovery fails.

Before We Proceed

Let’s have a quick overview of the SQL Server recovery process that comprises of the following three phases:

Posted on

Utilizing AWS Backup To Improve Your Recovery Time

Regardless of the size of your company, data backups and system recovery need to be a critical part of your IT operations and planning. Without a proper backup plan or recovery techniques put in place for when an IT disaster strikes, you are signing off on your business’s failure. Today, many technologies encompass the backup realm, and AWS has its own in-house feature to help you automatically back up and recover multiple other services too; AWS Backup.

AWS Backup is a fully-managed and automatic backup service first released by Amazon Web Services in January 2019 and was updated earlier this year. With this policy-based service, it is possible to automatically backup data from multiple AWS services in your cloud environments as well as your on-premises servers with the additional help of AWS Storage Gateway. 

Posted on

Redis Reconnection Resiliency

Background

It's a world of microservices. Such applications or microservices are required to store data temporarily with frequent and super quick access to avoid disk IO operations using Redis-like in-memory databases. These applications have multiple in-memory database clusters to handle huge amounts of traffic and to avoid request failures. To access this data quickly, applications are required to have the preconfigured, established pooled connections ready for service from the applications.Image title

Problem Statement

Applications built for resiliency have backup options in case of application or infrastructure failures. In-memory database clusters that exist in different data centers on different servers allow for backup connectivity in case of data center or server issues.