Database Recovery

How Always On Availability Groups Make DBAs Take A Close Look At System Admin Functions

In this article, we take a look at how Always On Availability group has changed the priority for DBAs and have induced them to keep an eye on System Admin functions With the coming of Always On Availability Groups in the 2012 edition of SQL Server, the System Administrator roles were bound to change, and this made all the DBAs a lot more concerned about their existing sys admin roles. The AlwaysOn Availability Groups feature is a feature that provides disaster recovery option, along with...

Read more »

How to Use SQL Server High Availability with Amazon Web Services

In this article, we look at how we can get AlwaysOn features in SQL Server to work with Amazon AWS Many organizations using SQL Server, make use of cloud services for not only storing active data but also backups. The most preferred options of cloud storage by such organizations are Azure Cloud and Amazon Web Services (AWS). Although, Azure cloud is specifically tailored for SQL Server users, and is a product of Microsoft, AWS has no such specifications. Still, both of these cloud storage...

Read more »

8 Essential Steps to Fix an Error in a Production SQL Server Database

In this article, we look at resolving an error that you may experience on a Production SQL Server database Facing an error in the Production server while using SQL Server is a great obstruction. You cannot continue working till you do not do away with the error. So here are a few things you should do every time you come across error in the production server. Find out the scope of corruption: The most important thing to do is to find out what is the scale of corruption. If it is large...

Read more »