Database Recovery

Understanding the Full Recovery Model in SQL Server and Exploring Its Challenges

The Full Recovery model in SQL Server comes with its own set of challenges and benefits, here we give an overview of both. One of the greatest things about using the SQL Server is the recovery models it provides. Depending upon the kind of data you are working on and your future requirements, you can select which recovery model will be best for you. The action of backing up data and then restoring it is a part of the recovery model provided in SQL Server. As of now, SQL users have the option...

Read more »

How to Restore with Recovery Option in SQL Server

The Restore with Recovery option available in SQL Server for restoring backups is explained in detail, along with T-SQL codes used in its implementation. Using SQL Server can be very tasking if you are not clear with its feature set, and what all to do with it. SQL Server is one of those software that floods the user with lots of options, features, commands etc. Apart from the bulk of data it allows you to store, it also gives you the option of backing it up. And beyond backing up the SQL...

Read more »

Working with a Scenario Where One Has to Initiate a Manual Force Failover

In this article we explain the Forced manual failover, when you should do it, and key points to remember. The Availability groups in MS SQL Server work as magic when it comes to failovers for securing data. In terms of availability groups, there are three different kinds of failovers that you can perform. These include an Automatic failover, which does not involve any data loss, a planned manual failover, this also does not involve any kind of data loss, and then comes the forced manual...

Read more »