SQL Server Database Recovery

Understanding the Difference between Index Scan and Index Seek in SQL Server

In this article we look at the subtle differences between an Index Scan and Index Seek mechanism in SQL Server Running a query in SQL Server is certainly something we would do on a regular basis. But what often troubles users about working with queries in SQL Server is the amount of time taken by them to give the required result. To do away with this delay, the users make use of the Query optimizer feature, but do you know how does the feature work? What is it about this feature that helps...

Read more »

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 »