Database Solutions

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 »

4 Key Tips to Avoid Deadlocks in SQL Server

The article suggests important tips to avoid Deadlocks in SQL Servers Although SQL Server has witnessed huge evolution in past couple of years, users still regularly face the situation of deadlocks. Ideally, a database server should be able to retrieve multiple requests but it often results in blocks. The conflicts where one process awaits the release of another resource are called blocks. And then there are Deadlocks. Imagine a situation where one person is asking the second to release a...

Read more »